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 “killie” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

489 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
killie10411489(None) 
billie85019171billie
gillie74816941gillie
killies113318111killies
kiltie103210961kiltie
willie94116451willie
billies93923502billies
collie83621992collie
dillies84122162dillies
fille84327402fill_e
fillies103420252fillies
fillip11268952fillip
ghillie11326352ghillie
gillied95512312gillied
gillies84120962gillies
girlie73711462girlie
hillier103413962hillier
illite63414922_illite
kellies113516852kellies
kelpie12308612kelpie
kiddie12359402kiddie
kidlike1137062kidlike
kilim11711902ki_lim
kill85533192kill__
killdee1266222killdee
killed113918772killed
killer104917952killer
killick1295312killick
killing123118722killing
kills94526182kill_s
kilties113014142kilties
kiltlike1134242kiltlike
mille75029132mill_e
millier93716702millier
millime112511402millime
milline92519112milline
mislie83219152mislie
mollie83517102mollie
nellie63614812nellie
rille55728732rill_e
silkie103313402silkie
sillier74017592sillier
sillies73425082sillies
tillite7313562tillite
villae95615382villae
villi86517852villi_
wallie93216802wallie
wellie92814912wellie
willied114611562willied
willies103920152willies
aioli5318313aioli_
aiolis6316843aiolis
airlike11310333airlike
airline7315033airline
aisle55223193aisl_e
alkie95520033_alkie
allee54932123_allee
allied74217153_allied
allies63827673_allies
axillae14248233axillae
bailie83818363bailie
ballies93725743ballies
belie75630383_belie
belle75827833bell_e
bellied104314073bellied
bellies94023723bellies
biali73419073biali_
bialies93618413bialies
bialis83617163bialis
bible95119423bibl_e
biblike1536893biblike
biggie103810933biggie
bikie113915883bi_kie
bilbies114712343bilbies
bile66147193bi_l_e
bilge87618913bi_lge
bilgier10358533bilgier
bill67239953bill__
billed94224903billed
biller84923483biller
billet86029723billet
billing103823853billing
billion92212173billion
billon83713833billon
billow114111223billow
bills75632863bill_s
billy105525363bill_y
birdie94013783birdie
birkie124110133birkie
birle75023633birl_e
bollix1538053bollix
bullae83416163bullae
bullied104514813bullied
bullier94116433bullier
bullies94121893bullies
callee84327293callee
cellae84915933cellae
celli76717693celli_
challie124012853challie
chilli114312773chilli_
chillier13328423chillier
chillies134113483chillies
chillis124411603chillis
cilia73016763ci_lia
cilice103213353cilice
civie103716353ci_vie
collide103214793collide
collied103316683collied
collier93618153collier
collies94326583collies
coolie83821603coolie
cullied104012353cullied
cullies94419963cullies
cullis84115993cullis
dallied93713613dallied
dallier84215383dallier
dallies84023193dallies
dellies83622213dellies
dickie133913113dickie
didie74120573di_die
dilate73220693dilate
dildoe8198673dildoe
dill55239983dill__
dilled84122223dilled
dills65530973dill_s
dilly94923783dill_y
dilute72911803dilute
diploe9810153diploe
dislike122913453dislike
dollied93811143dollied
dollies83620983dollies
doolie73916833doolie
eellike1138233eellike
faille93414743faill_e
falsie93513853falsie
fellies104119743fellies
felloe93513923felloe
ferlie92814053ferlie
file75446653fi_l_e
fill75540203fill__
filled104922263filled
filler94623623filler
filles94224523filles
fillet95027083fillet
filling113520803filling
filliped1435223filliped
fillips12298133fillips
fillo84319783fill_o
fillos94415083fillos
fills84632373fill_s
filly114424903fill_y
filmi105914003filmi_
filmic13348453filmic
filmier1237503filmier
filmis114610283filmis
filmlike1734443filmlike
filose96112503filose
finlike14279063finlike
folkie13369613folkie
follies103618943follies
follis93113903follis
frillier1136513frillier
gallic9411643gallic
gallied94115003gallied
gallies84122713gallies
ghillies12408663ghillies
gill56336193gill__
gilled84521633gilled
giller74519733giller
gilling93520383gilling
gillnet839733gillnet
gills64728193gill_s
gilly94321633gill_y
gimmie11298183gimmie
girlier8289523girlier
girlies83013703girlies
goalie7413163goalie
grille74315743grill_e
gullied93812063gullied
gullies84717313gullies
hickie153812473hickie
hili75626643hi_li_
hill76439503hill__
hilled104022223hilled
hiller94421633hiller
hilliest113914113hilliest
hilling113821773hilling
hillo84721653hill_o
hilloa94713033hilloa
hilloed113211293hilloed
hilloes103815963hilloes
hillos94618893hillos
hills85431353hill_s
hillside1254673hillside
hilly114422163hill_y
hiplike1637603hiplike
hipline12311423hipline
hippie132811243hippie
hollies103420813hollies
hoolie93217783hoolie
idle55423773_idl_e
ilia46026823_i_lia
ill37437103_ill__
iller54821293_iller
illites72415013_illites
ills47030423_ill_s
illude7327503_illude
illume8298223_illume
illy76925333_ill_y
indie63721473_indie
inlier63615363_inlier
iolite63221983_iolite
isle45121703_isl_e
jellied15419223jellied
jellies143816533jellies
jiglike19105333jiglike
jill116430273jill__
jillion14188933jillion
jills125122823jill_s
jimmie17376473jimmie
jollied15349273jollied
jollier142911003jollier
jollies143516273jollies
kale86533763k_al_e
kalif125021363k_alif
kalmia1238903kalmia
kaolin1039583kaolin
kaoline11310143kaoline
kebbie1435813kebbie
kelim11912553k_elim
kelly124617023kell_y
keloid11812623keloid
kelpies13289903kelpies
kelvin13117323kelvin
kewpie15465413kewpie
khalif1657833khalif
kibbe135211983ki_bbe
kibbi13449283kibbi_
kibbis14398473kibbis
kibble143910953kibble
kibe106523463ki__be
kibei114311543kibei_
kibeis12469803kibeis
kibla1139843kibl_a
kiblah1535583kiblah
kiblas1239323kiblas
kickier12349053kickier
kiddies133412283kiddies
kidvid1535033kidvid
kike76524803ki__ke
kilims1277903kilims
killable14168133killable
killdeer1362943killdeer
killdees1373963killdees
killers114215583killers
killicks1354873killicks
killings133710483killings
killjoy2142343killjoy
killock1255253killock
kiln85620993ki_l_n
kilned11368393kilned
kilning12289023kilning
kilns95112993ki_lns
kilo86028683ki_l_o
kilobit13126883kilobit
kiloliter1344013kiloliter
kilolitre1342603kilolitre
kilos95021483ki_los
kilt86144433ki_l_t
kilted113613833kilted
kilter103714343kilter
kilting123213853kilting
kilts95122193ki_lts
kilty125213903ki_lty
kinase104210653kinase
kindle114414243kindle
kindlier1345763kindlier
kine85643443ki__ne
kinglier1345633kinglier
kinglike1235093kinglike
kinin94917333ki_nin
kinkier10319433kinkier
kirtle10309473kirtle
kishke1254273kishke
kite85338253ki__te
kitelike1135733kitelike
kithe125917463ki_the
kitling123313573kitling
kitties113213623kitties
kittle104012173kittle
kiwi113211813ki_wi_
kiwis12328593ki_wis
klik74412663k__lik
kluge104910463k_luge
kookie9389843kookie
koppie14277883koppie
krill94213653krill__
krills104211283krill_s
kylix19416323k_ylix
kyrie123712903k_yrie
lie38264533___lie
lilied73913213li_lied
lilies63021413li_lies
lilylike1543853lilylike
liplike1337283liplike
lisle53916723lisl_e
lollies73116923lollies
mallee84525593mallee
mallei84414633mallei
mealie82519813mealie
midlife13248303midlife
midline102315103midline
milage93414123milage
mile66352583mi_l_e
milia72719573mi_lia
milieu8314113mi_lieu
milkier133411163milkier
mill66541493mill__
millage103112753millage
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
milliare1039153milliare
millieme12276803millieme
milliers102611903milliers
millimes122411373millimes
milliner102811863milliner
millines102718063millines
milling103223683milling
million91813143million
milliped1337383milliped
millirem1245693millirem
mills75435053mill_s
miltier93214963miltier
mislies92922283mislies
mislike132914833mislike
mislit83019693mislit
mislive122812693mislive
mollies93420233mollies
mullite9313013mullite
nellies73418723nellies
niblike1336703niblike
nielli636303nielli_
nill45634313nill__
nilled73919453nilled
nilling83619563nilling
nills54926673nill_s
nixie125114943ni_xie
oilier64417233oi_lier
oilily93111723oilily
oldie6415473_oldie
outlie62419533outlie
owllike1435713owllike
pallia83015603pallia
pallid93915293pallid
pallier94417173pallier
piggie103210773piggie
piglike14157313piglike
pile65649703pi_l_e
pilei74021783pilei_
pili66130363pi_li_
pilis75825203pi_lis
pill65339473pill__
pillage103412603pillage
pillar8314023pillar
pilled94222753pilled
pilling103722563pilling
pillion92011713pillion
pillow113110573pillow
pills74130973pill_s
pilose84514243pilose
pilule8411123pilule
pinkie124414273pinkie
pixie145415523pi_xie
plie65127393__plie
pollee83623273pollee
rallied83514083rallied
rallier73816283rallier
rallies73823343rallies
ralline73518413ralline
rallye95110163rallye
ramillie1045863ramillie
riblike1337333riblike
rifle85518333rifl_e
riflip1134723riflip
rile45650543ri_l_e
rill45140913rill__
rilled74525653rilled
rilles64725503rilles
rillet64828853rillet
rilling84023623rilling
rills55032713rill_s
sallied83316953sallied
sallier73320433sallier
sallies73227813sallies
saltie63422433saltie
selkie102811693selkie
selle54428313sell_e
sialic8313633sialic
sialid7314943sialid
sickie123715743sickie
sidle65124043sidl_e
silage72715303silage
silane62718053silane
silkier114411643silkier
silkies113715693silkies
silklike1135523silklike
sill45545163sill__
siller64026063siller
silliest84017103silliest
sillily10209783sillily
sills55135993sill_s
silly84527623sill_y
siltier73413863siltier
silvae92811093silvae
simile83115633simile
simlin8311733simlin
skill94316733skill__
skilled123110863skilled
skillet113512153skillet
skilling132911333skilling
skills104313923skill_s
skinlike1134873skinlike
stillier868833stillier
sullied83714483sullied
sullies74122233sullies
taille63116923taill_e
taillike1237863taillike
talkie103914443talkie
tallied83314753tallied
tallier72817223tallier
tallies73624603tallies
tallis63319963tallis
tallit63422733tallit
tellies73820513tellies
tilde65017353ti_lde
tile45451453ti_l_e
tilelike1237053tilelike
till45941213till__
tillage83111343tillage
tilled74722953tilled
tiller64222543tiller
tilling83522783tilling
tillites8312833tillites
tills54631713till_s
tinlike11248803tinlike
title54721073titl_e
tittie63213153tittie
tuille63012643tuill_e
tulle54019933tull_e
veillike1534603veillike
vile76139813vi_l_e
vill75235083vill__
villa85321233vill_a
village113610833village
villain1038483villain
villas96117263villas
villein1036753villein
villose1038053villose
vills86429323vill_s
villus93611223villus
violin9311983violin
virile9313433virile
wallies103320743wallies
wellies103719073wellies
widdie113410733widdie
wienie9229973wienie
wiglike15125853wiglike
wildlife1543253wildlife
wile75944383wi_l_e
wilier93217073wi_lier
wilily123310763wilily
will75737523will__
willed104722453willed
willer94021063willer
willet95124833willet
willing113821613willing
willow12369693willow
wills84528963will_s
willy115321913will_y
woolie93514483woolie
yill75628983yill__
yills83921553yill_s
yippie13277843yippie
zill135727623zill__
zillah1836563zillah
zillion16188773zillion
zills144020783zill_s

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 Filter1786911127160.373479064.3
2DLD Change Limit1127164895.50020493.8
3Display Results4894890.1563134.6
 (SQL Overall)1786914896.02929638.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.