Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pliskie” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
pliskie139454(None) 
pliskies1475971pliskies
pinkie124414272p_inkie
plisky1533712plisk_y
plisse8368402plis_se
alike95523963ali_k_e
alkie95520033al__kie
alsike1047913alsik_e
bhistie1236773bhistie
bikie113915883_bi_kie
birkie124110133_birkie
blastie92411393blastie
dickie133913113_dickie
flinkite1543623flinkite
flossie10337443flossie
flunkie1434513flunkie
friskier1535193friskier
glassie8329493glassie
griskin1236013griskin
hickie153812473_hickie
lassie64917743_lassie
like86040843_li_k_e
lisle53916723_lis_le
listee64223063_listee
luckie123611413_luckie
mislie83219153_mislie
muskie123412543_muskie
oilskin1144473oilskin
paise75028333pais__e
palisade1145833palisade
pastie85525523p_astie
peise75825773peis__e
pelisse967063pelis_se
peskier13319113p_eskier
pickier153912973p_ickier
pickle144215653p_ickle
piggie103210773p_iggie
pigskin1444353pigskin
pike106335213p_i_k_e
piki106520563p_i_ki_
pikis115116393p_i_kis
pinkies133818263p_inkies
pipkin14248603p_ipkin
piscine11610973p_iscine
pismire1135353p_ismire
piste75824603p_is_te
pistil83915073p_istil
pixie145415523p_i_xie
plashier1337613plashier
plasmic13249113plasmic
plasmid12239553plasmid
plasmin112410033plasmin
plastic112815063plastic
plastid102112523plastid
pliable111610323pliable
plicae10410953pli_cae
plicate11314513plicate
plie65127393pl___ie
plimsole1243663plimsole
plink115219123plink__
plinked143910893plinked
plinker134010963plinker
plinking153611243plinking
plinks124913263plink_s
plisses94411773plisses
plosive1236673plosive
pluckier16295073pluckier
plunkier14305323plunkier
plushier1375193plushier
poise75127893pois__e
popsie103013053pops_ie
postie84123963p_ostie
potsie83916033pots_ie
poussie936623poussie
prickier16368143prickier
prickle153611013prickle
primsie1137543primsie
prise74632613pris__e
prisere9310943prisere
prissier10157873prissier
prissies101712003prissies
pristine10313503pristine
prossie91812953prossie
prostie91617743prostie
puisne856353puis_ne
punkie123513613p_unkie
quickie2235513quickie
riskier1138423_riskier
sickie123715743_sickie
silkie103313403_silkie
siskin1079783_siskin
slinkier12206933slinkier
trickie132611033trickie
twinkie1434573twinkie
whiskies1835953whiskies

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.486367677.0
2DLD Change Limit134027955.82623005.0
3Display Results95950.0462065.2
 (SQL Overall)178691956.35828104.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.