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

121 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
googols93548(None) 
googol835841googol_
gogos77516522g_ogo_s
googly11417882goog_ly
goorals838702goorals
gorgons938852gorgons
mongols103310822mongols
argols74514613_argols
bongoes104314113bongoes
bongos95316653bongo_s
booboos1138143booboos
boocoos1137753boocoos
boogers104514633boogers
boogeys13476873boogeys
boogies103719013boogies
boohoos1237993boohoos
bookoos1337503bookoos
cogons96818113_cogons
congoes103617303congoes
congos94219883congo_s
congous103615083congous
consols92914073consols
cools75632633_co_ols
diobols1036543diobols
dongola945473dongola
dongolas1045343dongolas
doodoos9107623doodoos
doowops1363943doowops
drools74412813dro_ols
fools86824203_fo_ols
forgoes11311353forgoes
formols12299413formols
gambols1238593gambols
gaols66717573g__aols
gasohols1243723gasohols
ghouls1036043gho_uls
gigolo836533g_igolo
gigolos934693g_igolos
gigots83911953g_igots
gingals9109313gingals
girosols984653girosols
globous1036503globous
gloggs935033glog_gs
glooms96211683glo_oms
glycols1344133glycols
gnomons1035753gnomons
goals65521293g_o_als
goboes95914443g_oboes
gobos86219383g_obo_s
godsons966663godsons
goggle94511573g_oggle
goggles103510793goggles
goggly12337053g_oggly
gogo69722833g_ogo__
gombos114311093gombo_s
gondola946663gondola
gondolas1046193gondolas
gongs74921613gong__s
gonofs10459863g_onofs
goobers10219623goobers
goodbys14354173goodbys
goodies93516993goodies
goodly11419303goo_dly
goods75124483g_o_ods
goofily14105353goofily
goofs94821003g_o_ofs
googlies1086763googlies
gooks105422883g_o_oks
gooneys11407073gooneys
goonies83618333goonies
goons65326773g_o_ons
goops86620963g_o_ops
gooral7310463gooral_
goos57644913g_o_o_s
gooses75723053goo_ses
gorals76917653g_orals
gorgeous1046293gorgeous
gorgers94813643gorgers
gorges85321893gorg_es
gorgets94711783gorgets
gorgon8310243gorgo_n
gospels1035593gospels
gougers94911763gougers
gouges86318693goug_es
gregos847533grego_s
grogs76319413grog__s
grooms94512523gro_oms
grovels11427813grovels
growls104711113gro_wls
hoodoos11109293hoodoos
hoopoes121212483hoopoes
hoopoos1298543hoopoos
hoosgows1542913hoosgows
isogons8217613isogons
koodoos12116393koodoos
logons79818173_logons
logos67225333_logo_s
moguls948553_moguls
mongoes103415713mongoes
mongol94912533mongol_
mongos94318623mongo_s
mools76027173_mo_ols
noogies82814583noogies
obols73715863__obols
osmols8137313_osmols
podsols1056513podsols
podzols1934683podzols
polyols1238493polyols
pools74427703_po_ols
shools94919013sho_ols
snools65715883sno_ols
sokols10399093_sokols
sorgos74514663sorgo_s
sotols63714473_sotols
spools85115913spo_ols
stools65117023sto_ols
toluols735823toluols
tools55325243_to_ols
trogons83410723trogons
voodoos1196343voodoos
wools84421463_wo_ols

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.393454684.5
2DLD Change Limit1340271216.50020619.5
3Display Results1211210.0304033.3
 (SQL Overall)1786911216.92325811.2
 
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.