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

184 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
googlies108676(None) 
boogies103719012boog_ies
coolies93824962coo_lies
doolies83920712doo_lies
ghoulies1235392ghoulies
goalies8316022g_oalies
goggles103510792goggl_es
gogglier1153922gogglier
goggliest1234062goggliest
goodies93516992goo_dies
goodlier1035792goodlier
goodliest1146392goodliest
goonies83618332goo_nies
noogies82814582noog_ies
woolies104117362woo_lies
woollies1147412woollies
boggles113411823boggl_es
bogies94724313_bog_ies
bogles95020833_bogl_es
boobies113718203boo_bies
boodies103721443boo_dies
boodles103416043boodl_es
boogie93515993boog_ie_
boogied11379283boog_ied
bookies133819403boo_kies
boonies93422483boo_nies
booties94124613boo_ties
botflies1336733botflies
bougies103715183boug_ies
brollies1039533brollies
colies84837053_co_lies
collies94326583_collies
complies14314523complies
cookies133719273coo_kies
coolie83821603coo_lie_
coonties10513803coonties
cooties93725733coo_ties
dhoolies1246963dhoolies
doggies103613023_doggies
dogies85022253_dog_ies
doilies84017363_doilies
dollies83620983_dollies
dongles93212873dongl_es
doobies103915673doo_bies
doodies94218773doo_dies
doodles93614163doodl_es
doolees83711613doo_lees
doolie73916833doo_lie_
doozies173812723doo_zies
doylies114512573_doylies
fogies104118063_fog_ies
follies103618943_follies
foodies113416753foo_dies
footies103721543foo_ties
footles103715713footl_es
footsies1139643footsies
foozles19329543foozl_es
gadflies1334733gadflies
gaggles103512593gaggl_es
gallies84122713g_allies
ganglier1047603ganglier
gangliest1137673gangliest
gargles94214893gargl_es
geologies11410643geolog_ies
ghillies12408663ghillies
ghoulie1144263ghoulie_
giggles103312933giggl_es
gigglier1154323gigglier
giggliest1234323giggliest
gillies84120963g_illies
gingelies11277503gingelies
girlies83013703g_irlies
glories81915913glo_ries
glossies93311253glossies
glowflies1642893glowflies
goalie7413163g_oalie_
gobbles123512583gobbl_es
gobies95418063g_o_bies
goblins1039243g_oblins
godlier938893g_odlier
godliest1039453g_odliest
goggle94511573goggl_e_
goggled11348953goggl_ed
goggler10379323goggl_er
gogglers11276713gogglers
goggling10246283goggling
goglet84618583g_ogl_et
goglets9379783g_oglets
gonglike1455423gonglike
goodbyes15333503goodbyes
goodie83613993goo_die_
goodwives1742233goodwives
goofier11339313goo_fier
goofiest12289393goo_fiest
googly11417883googl__y
googols935483goog_ols
gooier73516213goo__ier
gooiest82813883goo__iest
goonie73615563goo_nie_
goonier83612843goo_nier
gooniest93213003goo_niest
goopier103910573goo_pier
goopiest112710553goo_piest
gooses75723053goo__ses
goosier83512563goo_sier
goosiest92911823goo_siest
gorges85321893gorg__es
gouges86318693goug__es
groggier1134343groggier
groggiest1235093groggiest
groupies1137523groupies
growlier1234883growlier
growliest1335583growliest
guggles103410543guggl_es
gullies84717313g_ullies
gurgles94312873gurgl_es
hoagies112811993hoag_ies
hogties112813993_hogties
holies94630033_ho_lies
hollies103420813_hollies
homilies132710113homilies
hongies112716473hong_ies
hoochies1639603hoochies
hoodies113419833hoo_dies
hookies144017443hoo_kies
hoolie93217783hoo_lie_
hourlies1138343hourlies
joggles164410413joggl_es
jollies143516273_jollies
lollies73116923_lollies
longies82916553long_ies
longlines1047983longlines
loobies93814103loo_bies
looies65025833loo__ies
loonies73919543loo_nies
lovelies1139893lovelies
moggies113111723_moggies
molies84429513_mo_lies
mollies93420233_mollies
noodles83513193noodl_es
noogie73612313noog_ie_
nookies113414963noo_kies
ogles65223183__ogl_es
ologies8615023olog_ies
oodles73517183_oodl_es
oodlins83210513_oodlins
oogamies1147413_oogamies
oogenies9311583_oogenies
oolites72817843_oo_lites
oologies9312993oolog_ies
orgies72316093_org_ies
outlies72421993_outlies
pogies94123543_pog_ies
polies84034583_po_lies
poodles103013513poodl_es
porgies103017003porg_ies
roofies103014413roo_fies
rooflines1245373rooflines
rookies113917103roo_kies
roomies93017243roo_mies
rootles73215633rootl_es
roughies1298323roughies
shooflies1544143shooflies
stogies8413693stog_ies
stoolies8311083stoolies
toggles93710973toggl_es
toonies73719883too_nies
tootles72915603tootl_es
tootsies848613tootsies
toughies1278243toughies
trollies8310233trollies
uglies7412323__uglies
wobblies15297233wobblies
woodies113517153woo_dies
woolie93514483woo_lie_
woolier103612353woo_lier
wooliest113011643woo_liest
woollier1155433woollier
woolliest1235853woolliest
zoogenies1946833zoogenies
zooglea1733373zoogl_ea
zoogleas1843373zoogleas
zoogloea1842283zoogloea
zoogloeas1941993zoogloeas

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621846.80021494.4
3Display Results1841840.0603066.7
 (SQL Overall)1786911847.28024545.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.