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

132 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
novalike153622(None) 
dovelike16157132dovelike
lavalike1536282lavalike
nooklike1134872nooklike
noselike12158572noselike
novelise1137952novelise
novelize2046842novelize
alike95523963___alike
boatlike1457963boatlike
boltlike1436313boltlike
bowlike16349473bo_wlike
bowllike1734863bowllike
boxlike20267073bo_xlike
cavelike1738213cavelike
cocklike1536733cocklike
cokelike1336813cokelike
comblike1846293comblike
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
doglike13207453do_glike
domelike15177753domelike
downlike1636183downlike
foamlike1735143foamlike
focalise131210373focalise
focalize22139503focalize
folklike1434773folklike
footlike1537253footlike
forklike1435813forklike
foxlike21226223fo_xlike
gnomelike1643563gnomelike
goadlike1435883goadlike
goalie7413163go_ali_e
goatlike1346293goatlike
godlike1387563go_dlike
gonglike1455423gonglike
hoblike16158303ho_blike
hoelike141411163ho_elike
hoglike15157733ho_glike
homelike17179533homelike
hoodlike1636563hoodlike
hooflike1834853hooflike
hooklike1435123hooklike
hooplike1736773hooplike
hornlike1536503hornlike
hoselike15179643hoselike
ivylike1734283_ivylike
knoblike1343163kno_blike
knotlike1144003kno_tlike
localise101511853localise
localite101411543localite
localize191410483localize
loftlike1534393loftlike
lookalike1242493lookalike
lordlike1345813lordlike
moatlike1446993moatlike
moonlike1476643moonlike
moralise10314913moralise
moralize19313923moralize
mosslike1435453mosslike
mothlike1736063mothlike
nasalise848863nasalise
nasalize1748183nasalize
necklike13104563necklike
nestlike1236083nestlike
netlike11308913n_etlike
niblike1336703n_iblike
nodality12127423nodality
nonelite8313613nonelite
nonlife1038553no_nlife
nonsaline948413nonsaline
nonvalid1245603nonvali_d
nopalito1046063nopalito
normalise11259423normalise
normalize203010103normalize
notarize1749293notarize
novaculite1551883novaculite
novae85913123nova___e
novation111710013novation
novelised1344983novelised
novelises1247373novelises
novelist1149453novelist
novelized2245313novelized
novelizer2144703novelizer
novelizes2146223novelizes
novelle1058233novel_le
novice1138433nov__ice
nunlike11258073n_unlike
nutlike113110113n_utlike
oaklike10268003_oaklike
oarlike113411193_oarlike
oatlike113412403_oatlike
opaline9412483_opaline
ovality1377593_ovality
ovenlike1535013_ovenlike
owllike1435713_owllike
oxlike17307473_o_xlike
pealike131211273_pealike
podlike14108553po_dlike
poetlike1436733poetlike
popelike16177853popelike
potlike13910123po_tlike
rocklike1335903rocklike
rodlike1288263ro_dlike
rooflike1534623rooflike
rootlike1236613rootlike
ropelike14157853ropelike
roselike12169183roselike
snowlike1534973sno_wlike
soaplike1436903soaplike
sodalite9109593sodalite
songlike1336523songlike
sonlike112110713so_nlike
soullike1236813soullike
souplike1436333souplike
tealike111111083_tealike
toadlike1336143toadlike
toelike11149823to_elike
tomblike1645143tomblike
totalise8312503totalise
totalize17311523totalize
toylike14157243to_ylike
unalike11311533_unalike
valine94623093__valine
valise92917643__valise
vocalise131510813vocalise
vocalize221310153vocalize
wavelike1836613wavelike
wolflike1834063wolflike
womanlike1843453womanlike
woollike1534983woollike
wormlike1735313wormlike

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 Limit1461621327.23620199.3
3Display Results1321320.0632095.2
 (SQL Overall)1786911327.71923149.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.