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

92 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
ghoulie114426(None) 
ghoulies1235391ghoulies
ghillie11326352ghillie
ghoul959052ghoul__
ghoulish1543542ghoulish
ghouls1036042ghoul_s
goalie7413162g_oalie
groupie1045782groupie
hoolie93217782_hoolie
aboulia966553aboulia
aboulic1156283aboulic
bougie93613273_bougie
boule74828043_boul_e
boulle84614613_boulle
challie124012853challie
charlie123011923charlie
choline122915383cho_line
chouse116017563chou_se
collie83621993_collie
coolie83821603_coolie
coulee8323513_coulee
coulis84018763_coulis
dhole95215363dho_l_e
dhoolies1246963dhoolies
dhootie1136473dhootie
doolie73916833_doolie
ghibli1243493ghibli_
ghiblis1353343ghiblis
ghillies12408663ghillies
ghostier1235383ghostier
ghostlier1343343ghostlier
ghostlike1743353ghostlike
gillie74816943g_illie
girlie73711463g_irlie
globule1034383globul_e
globulin1144193globulin
goalies8316023g_oalies
goblin939503g_oblin
godlier938893g_odlier
godlike1387563g_odlike
goodie83613993g_oodie
goodlier1035793goodlier
googlies1086763googlies
goonie73615563g_oonie
gouge78220063g_ou_ge
gourde8107933g_ourde
goutier82612353g_outier
groupies1137523groupies
grouse74315023grou_se
groutier9297173groutier
growlier1234883growlier
guile64521133g__uile
haulier1059943_haulier
hoagie102310013_hoagie
hoblike16158303_hoblike
hoelike141411163_hoelike
hoglike15157733_hoglike
hogtie102711773_hogtie
hole77553393_ho_l_e
holier94921623_ho_lier
holies94630033_ho_lies
hollies103420813_hollies
homie104622533_ho_mie
honkie133011673_honkie
hoodie105116143_hoodie
hoplite12311073_hoplite
hotline10712353_hotline
hottie92514383_hottie
houri85915253_houri_
houris94514583_houris
hourlies1138343_hourlies
house89131423_hou_se
howdie13349733_howdie
hoyle11314413_hoyl_e
joule124918203_joul_e
louie55023513_lou_ie
mollie83517103_mollie
moulin8313283_moulin
ourie54027303__ourie
outlie62419533__outlie
shoalier1137073shoalier
shortie10411343shortie
should1038033shoul_d
shoulder1234753shoulder
stoolie739723stoolie
stourie7469353stourie
thole85620843tho_l_e
thulia936113th_ulia
wheelie1336193wheelie
whole114418093who_l_e
whoopie15295933whoopie
woolie93514483_woolie

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.406440125.6
2DLD Change Limit134027926.45320769.7
3Display Results92920.0462000.0
 (SQL Overall)178691926.90525878.5
 
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.