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

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

118 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
lookalikes134185(None) 
lookalike1242491lookalike_
hooklike1435123hook_like_
localises111411463l_ocalises
localites111210433l_ocalites
localizes201510543l_ocalizes
nooklike1134873nook_like_
alkalies12158544_alkali_es
alkalises13167484_alkalises
alkalizes22157354_alkalizes
anomalies1149284anomali_es
bloodlike1643864bloo_dlike_
bloodlines1344184bloo_dlines
bookies133819404book__i_es
booklice1644754book_lice_
booklores1545074book_lores
bookplates1843054bookplates
brooklike1453274brook_like_
brooklimes1841904brook_limes
clocklike1642824clock_like_
cocklike1536734cock_like_
cokelike1336814_cokelike_
cookeries151210644cookeri_es
cookies133719274cook__i_es
coolies93824964coo__li_es
corklike1335994cork_like_
doolies83920714doo__li_es
focalises14139954_focalises
focalizes23159324_focalizes
folklike1434774folk_like_
folklives1942674folk_lives
footlike1537254foo_tlike_
forklike1435814fork_like_
formalises15258994formalises
formalizes242710074formalizes
fortalices1545514fortalices
globalises1354594globalises
globalizes2244644globalizes
goalies8316024_go_ali_es
googlies1086764goo_gli_es
hoodlike1636564hoo_dlike_
hooflike1834854hoo_flike_
hookies144017444hook__i_es
hooplike1736774hoo_plike_
kylikes1333584___kylikes
labializes2145794labializes
lakelike1137384l_akelike_
lavalike1536284l_avalike_
legalises1038564l_egalises
legalizes1938674l_egalizes
lionlike1234984lio_nlike_
lobelines1138564l_obelines
locales93715094l_ocal__es
localise101511854l_ocalise_
localised12167864l_ocalised
localisms13148734l_ocalisms
localists11149794l_ocalists
localite101411544l_ocalite_
localities1259734l_ocalities
localize191410484l_ocalize_
localized21168834l_ocalized
localizer20147714l_ocalizer
localizers21165254l_ocalizers
locatives1446564l_ocatives
lockages1536724locka__ges
loftlike1534394l_oftlike_
lollies73116924l_o_lli_es
longlines1047984l_onglines
loobies93814104loo__bi_es
looies65025834loo___i_es
lookisms1444794look__isms
lookists1245714look__ists
looksisms1542384look_sisms
loonies73919544loo__ni_es
lordlike1345814l_ordlike_
lovelies1139894l_oveli_es
lowlifes1434334l_o_wlifes
lowlives1434574l_o_wlives
loyalisms14156624l_oyalisms
loyalists12137474l_oyalists
loyalties1244484l_oyalties
moonlike1476644moo_nlike_
moralises11314004_moralises
moralizes20312864_moralizes
nookies113414964nook__i_es
normalises12228504normalises
normalizes21259644normalizes
novalike1536224_novalike_
oaklike10268004_oak_like_
oogamies1147414_oogami_es
oolites72817844_oo__lites
ooralis7312554_oorali__s
opalines10311424__opalines
oxalises1538504__oxalises
rockabies1744224rockabi_es
rocklike1335904rock_like_
rockslides1752774rockslides
rooflike1534624roo_flike_
rooflines1245374roo_flines
rookeries13138174rookeri_es
rookies113917104rook__i_es
rootlike1236614roo_tlike_
silkalines1443574silkalines
smokelike1443494smokelike_
socialises1258254socialises
socialites1247504socialites
socializes2148404socializes
sodalites10128694_sodalites
soundalikes1651914soundalikes
toothlike1643724toothlike_
totalises9311784_totalises
totalizes18311054_totalizes
vocalises141710334_vocalises
vocalizes231610104_vocalizes
woolies104117364woo__li_es
woollies1147414woo_lli_es
woollike1534984woo_llike_
wooralis1145804woorali__s

Search took 10 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 Filter1786911614500.436409841.7
2DLD Change Limit1614501189.37317225.0
3Display Results1181180.0462565.2
 (SQL Overall)1786911189.85518132.0
 
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.