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

135 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
onloads824667(None) 
onload7268631onload_
unloads8278521unloads
downloads1443602downloads
inroads837042inroads
loads65323372__loads
offloads1542722offloads
ogdoads1042992ogdoads
onlays9398712onl_ays
onloaded1044742onloaded
reloads8911312reloads
unleads8228622unleads
unload73010802unload_
uploads10266502uploads
vanloads1264162vanloads
allods73615083allo_ds
anlas55626933anl_a_s
anoas57226493an_oa_s
armloads1144233armloads
ballads104212913ballads
bloats85215763_bloats
blonds95213343_blonds
bloods94614843_bloods
boatloads1243193boatloads
bombloads1642443bombloads
broads94515153_broads
busloads1144153busloads
byroads1335293byroads
carloads1138393carloads
clads85722733_cl_ads
cloaks124411263_cloaks
clods85320863_clo_ds
clouds94612353_clouds
coleads102911423coleads
colloids11310173colloids
concords1358593concords
conelrads1244263conelrads
conoids10813883con_oids
deleads9379703deleads
download1343833download_
enfolds11136253enfolds
enneads834733enneads
floats96816253_floats
floods104511653_floods
glads75620613_gl_ads
gloams95210663_gloams
gloats74515423_gloats
goads77022853__goads
gonads84511733gon__ads
haloids113012553haloids
holloas103814943holloa_s
hoptoads1444143hoptoads
iliads7448673_iliads
inboards1145843inboards
infolds11137023infolds
inlands838783inlands
inlays9389873inl_ays
inroad737933inroad_
keloids1288663keloids
kilorads1344423kilorads
kneads11357093kn_eads
lads56549133__l_ads
leads66028493__leads
load56730603__load_
loafs85616993__loafs
loams75619863__loams
loans56026463__loans
loids66220703__loids
lords64923503__lords
meloids10911453meloids
milords10117853milords
monads94515303mon__ads
naiads739013_naiads
nicads938333_nicads
nods55838223_n_o_ds
nolos54423353nolo__s
nomads94711603_nomads
nonlocals1144803nonlocals
nonwords1247463nonwords
oblongs1033533oblongs
octads987333o_ctads
offload1443203offload_
ogdoad943523ogdoad_
oilcans936813oilcans
oilways1334873oilways
olds55926573o_l__ds
ollas54218283o_lla_s
onboard1046503onboard
onions64016433onio_ns
onlay84212943onl_a_y
onloading1145163onloading
onos46229003on_o__s
onwards1137173onwards
oolongs845953oolongs
opioids1036523opioids
oreads73915773o_reads
orlons6411013orlo_ns
orlops847303orlo_ps
outleads9278763outleads
overloads13127663overloads
ovoids10456923o_voids
oxbloods1842753oxbloods
oxfords1842893oxfords
payloads1445293payloads
pleads94613953_pleads
plods85719293_plo_ds
preloads1157513preloads
reload7413893reload_
reloans7313133reloans
roads66523623__roads
salads75316963sal_ads
sloids73712693_sloids
slojds14345473_slojds
sloyds10346293_sloyds
snoods74312453sn_oods
sonhoods1247083sonhoods
toads65621073__toads
uncloaks1444133uncloaks
unclouds1144883unclouds
unfolds11146803unfolds
unhoods1137503unhoods
unlade72714153unl_ade
unlades82612833unl_ades
unlays93810493unl_ays
unlead73312373unlead_
unloaded1049533unloaded
unloader936643unloader
unloaders1044403unloaders
unlocks1337063unlocks
unmolds10135743unmolds
upload9257783upload_
vanload1144703vanload_
wagonloads155813wagonloads
woads94818443__woads
workloads1742743workloads

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 Limit1340271356.28021341.9
3Display Results1351350.0462934.8
 (SQL Overall)1786911356.73226543.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.