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

153 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
ghillie1132635(None) 
ghillies12408661ghillies
gillie74816941g_illie
billie85019172_billie
challie124012852challie
chilli114312772chilli_
chillier13328422chillier
chillies134113482chillies
chillis124411602chillis
ghibli1243492ghibli_
ghiblis1353342ghiblis
ghoulie1144262ghoulie
gillied95512312g_illied
gillies84120962g_illies
girlie73711462g_irlie
grille74315742grill_e
hillier103413962_hillier
killie104114892_killie
willie94116452_willie
axillae14248233axillae
bailie83818363bai_lie
bhistie1236773bhistie
billies93923503_billies
challies133915643challies
challis124613463challis
charlie123011923charlie
chicle134312543chicl_e
childe124711213chi_lde
childlier1543093childlier
childlike1942983childlike
chile105626893chi_l_e
chili106218483chi_li_
chilies124218303chi_lies
chilis115517873chi_lis
chill105619873chill__
chilled133310933chilled
chiller124112183chiller
chilliest14358913chilliest
chillily1644113chillily
chilling143512183chilling
chills114717703chill_s
chillum1435443chillum
chilly144113223chill_y
chippie16297693chippie
chitlin12269283chitlin
collie83621993_collie
dillies84122163_dillies
faille93414743faill_e
fille84327403_fill_e
fillies103420253_fillies
fillip11268953_fillip
frillier1136513frillier
gainlier965673gainlier
galilee8312213galilee
gallic9411643g_allic
gallied94115003g_allied
gallies84122713g_allies
ghoulies1235393ghoulies
ghyll1246323ghyll__
ghylls1335143ghyll_s
gill56336183g_ill__
gilled84521633g_illed
giller74519733g_iller
gilling93520383g_illing
gillnet839733g_illnet
gills64728193g_ill_s
gilly94321633g_ill_y
gimmie11298183g_immie
girlier8289523g_irlier
girlies83013703g_irlies
goalie7413163g_oalie
grill64617893grill__
grillade1085143grillade
grillage1055613grillage
grilled94012833grilled
griller84513353griller
grilles83715023grilles
grilling103811533grilling
grills74314803grill_s
grilse7399503gri_lse
grislier935793grislier
guile64521133gui_l_e
guiltier934493guiltier
gullied93812063g_ullied
gullies84717313g_ullies
hickie153812473_hickie
hili75626633_hi_li_
hill76439493_hill__
hilled104022223_hilled
hiller94421633_hiller
hilliest113914113_hilliest
hilling113821773_hilling
hillo84721653_hill_o
hilloa94713033_hilloa
hilloed113211293_hilloed
hilloes103815963_hilloes
hillos94618893_hillos
hills85431353_hill_s
hillside1254673_hillside
hilly114422163_hill_y
hiplike1637603_hiplike
hipline12311423_hipline
hippie132811243_hippie
hollies103420813_hollies
hoolie93217783_hoolie
illite63414923__illite
killies113318113_killies
kiltie103210963_kiltie
mille75029133_mill_e
millier93716703_millier
millime112511403_millime
milline92519113_milline
mislie83219153_mislie
mollie83517103_mollie
nellie63614813_nellie
phalli1148263phalli_
phallic1447293phallic
philtre12105213philtre
phyllite1645743phyllite
ramillie1045863ramillie
rille55728733_rill_e
shellier1138393shellier
sheltie10109913sheltie
shill85325333shill__
shilled113313623shilled
shilling123315383shilling
shills94519613shill_s
shilpit1247103shilpit
silkie103313403_silkie
sillier74017593_sillier
sillies73425083_sillies
stillier868823stillier
taille63116923taill_e
taillike1237863taillike
thalli958923thalli_
thallic1246553thallic
thill85918733thill__
thills95515383thill_s
thiolic1247323thiolic
tillite7313563_tillite
tuille63012643tuill_e
veillike1534603veillike
villae95615383_villae
villi86517853_villi_
wallie93216803_wallie
wellie92814913_wellie
wheelie1336193wheelie
while115418693whi_l_e
whiplike2043813whiplike
whirlier14175293whirlier
whirlies14167373whirlies
willied114611563_willied
willies103920153_willies

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.423422437.4
2DLD Change Limit1340271536.23321502.8
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.71926594.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.