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 “killick” 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.

99 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
killick129531(None) 
killicks1354871killicks
killock1255251killock
hillock1646692hillock
killie104114892killi_e
killies113318112killies
killing123118722killing
killocks1354792killocks
klick105311432k__lick
niblick1544452niblick
rollick1335612rollick
airsick1395333airsick
billie85019173billi_e
billies93923503billies
billing103823853billing
billion92212173billion
bullock1537193bullock
cilice103213353ci_lice
click135217953__click
cowlick1835263cowlick
dillies84122163dillies
fillies103420253fillies
filling113520803filling
fillip11268953filli_p
fillips12298133fillips
filmic13348453filmic_
flick145017213__flick
gallic9411643gallic_
gallica1047463gallica
gillie74816943gilli_e
gillied95512313gillied
gillies84120963gillies
gilling93520383gilling
gimmick1843273gimmick
hillier103413963hillier
hilling113821773hilling
hillocks1736063hillocks
hillocky2053403hillocky
illicit949833_illicit
illite63414923_illite
jillion14188933jillion
kellies113516853kellies
kick96026063k___ick
kidlike1137063kidlike
kilim11711893ki_li_m
kilims1277903ki_lims
kill85533173kill___
killdee1266213killdee
killed113918773kill_ed
killer104917953kill_er
killers114215583killers
killings133710483killings
killjoy2142343killjoy
kills94526173kill__s
kilning12289023kilning
kiltie103210963kilti_e
kilties113014143kilties
kilting123213853kilting
kiltlike1134243kiltlike
kitling123313573kitling
klicks11468723k__licks
klik74412653k__li_k
lick106935073___lick
millier93716703millier
millime112511403millime
milline92519113milline
milling103223683milling
million91813143million
miskick1435613miskick
mullock1535713mullock
niblicks1643763niblicks
nilling83619563nilling
nitpick1543783nitpick
pilling103722563pilling
pillion92011703pillion
pollack1567333pollack
pollock1546843pollock
rilling84023623rilling
rollicks1444893rollicks
rollicky1742693rollicky
sialic8313633sialic_
silica8311243si_lica
sillier74017593sillier
sillies73425083sillies
sillily10209783sillily
silvics1235563silvics
skilling132911333skilling
skinflick1771223skinflick
slick115520523__slick
tilling83522783tilling
tillite7313563tillite
unslick1356023unslick
villi86517853villi__
willie94116453willi_e
willied114611563willied
willies103920153willies
willing113821613willing
zillion16188773zillion
ziplock2454413ziplock

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.1401276364.3
2DLD Change Limit134027996.40620922.1
3Display Results99990.0462152.2
 (SQL Overall)178691996.59227107.3
 
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.