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

179 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
onload726863(None) 
onloads8246671onloads
unload73010801unload
download1343832download
inroad737932inroad
load56730602__load
offload1443202offload
ogdoad943522ogdoad
onboard1046502onboard
onlay84212942onl_ay
onloaded1044742onloaded
reload7413892reload
unlead73312372unlead
unloads8278522unloads
upload9257782upload
vanload1144702vanload
abroad9310943abroad
afloat9315153afloat
allod64418383allo_d
aloud65018073_aloud
anlas55626933anl_as
anoa45634473an_oa_
anoas57226493an_oas
armload1044293armload
ballad94315323ballad
bloat75229923_bloat
blond85618373_blond
blood85319523_blood
boatload1143403boatload
bombload1543143bombload
broad84817693_broad
busload1044683busload
byroad1236623byroad
carload1039783carload
clad76225823_cl_ad
cloak115214013_cloak
clod76124613_clo_d
cloud86716423_cloud
colead94114643colead
colloid10312883colloid
concord12510343concord
conelrad1145603conelrad
conoid9818883con_oid
delead84112343delead
downloads1443603downloads
enfold10137613enfold
ennead736253ennead
float85928573_float
flood95215603_flood
glad65624013_gl_ad
gloam86015943_gloam
gloat65427683_gloat
goad66830983__goad
gonad75216053gon__ad
haloed104717603haloed
haloid104317763haloid
holloa94914823holloa_
holloaed12157393holloaed
holloas103814943holloas
holloed113812753holloed
hoptoad1344323hoptoad
iliad64613463_iliad
inboard1037063inboard
infold10128163infold
inlaid7310143inlaid
inland7310313inland
inlay85214323inl_ay
inroads837043inroads
keloid11812623keloid
kilorad1245393kilorad
knead10429663kn_ead
lad48165703__l_ad
lead56038853__lead
loads65323373__loads
loaf76734903__loaf
loam65630483__loam
loan47436453__loan
loid55531493__loid
lord55032083__lord
loud55228043__loud
meloid9616003meloid
milord999573milord
monad85519473mon__ad
naiad6313403_naiad
nicad8312613_nicad
nod47549563_n_o_d
nolo46229313nolo__
nolos54423353nolo_s
nomad86016183_nomad
nonfood1156653nonfood
nonlocal1047513nonlocal
nonloyal1145123nonloyal
nonword1149153nonword
oblong935383oblong
oceloid1037973oceloid
octad81510653o_ctad
offloads1542723offloads
ogdoads1042993ogdoads
ogled75915963ogl_ed
oilcan837793oilcan
oiled64429473oil_ed
oilman839483oilman
oilway1235743oilway
old47033463o_l__d
olea46532723o_lea_
olla44821173o_lla_
ollas54218283o_llas
ology94113113o_logy
onefold1144493onefold
onion54320973onio_n
onions64016433onions
oniony9369703oniony
onlays9398713onlays
online6315843online
onloading1145163onloading
only75319723onl__y
ono36838033on_o__
onos46229003on_o_s
onto46127663onto__
onward1039053onward
oology103210253oology
oolong738073oolong
opioid9310083opioid
orad56031693o__rad
oread64619603o_read
orlon5415003orlo_n
orlons6411013orlons
orlop7410903orlo_p
orlops847303orlops
outlead83311103outlead
overload12119283overload
ovoid94811023o_void
oxblood1743603oxblood
oxford1763663oxford
payload1336403payload
plead85818463_plead
plod76723273_plo_d
preload1049813preload
reloads8911313reloads
reloan6415693reloan
road56332113__road
salad65321833sal_ad
siloed74615303siloed
sloid64619713_sloid
slojd13378843_slojd
sloyd9409683_sloyd
snood64616163sn_ood
soloed74515743soloed
sonhood1168313sonhood
toad55830183__toad
ulnad65611453_ulnad
unclad938913unclad
uncloak1365473uncloak
uncloud1046433uncloud
undead82711903undead
unfold10179703unfold
unfond10149113unfond
unhood1039233unhood
unlade72714153unl_ade
unlaid7311753unlaid
unlay84613703unl_ay
unleads8228623unleads
unled64021073unl_ed
unloaded1049533unloaded
unloader936643unloader
unlobed10219743unlobed
unlock1248533unlock
unloved112310533unloved
unmold9148313unmold
unread73412673unread
unsold71410513unsold
untold7149683untold
uploads10266503uploads
vanloads1264163vanloads
wagonload145873wagonload
woad85523943__woad
workload1643023workload
xyloid1738193xyloid
yclad11246383ycl_ad

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161794.72023880.5
3Display Results1791790.0463891.3
 (SQL Overall)1786911795.14234751.3
 
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.