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

309 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
unload7301080(None) 
onload7268631onload
unlead73312371unlead
unloads8278521unloads
upload9257781upload
busload1044682busload
inroad737932inroad
load56730602__load
onloads8246672onloads
reload7413892reload
ulnad65611452u_lnad
unclad938912unclad
uncloak1365472uncloak
uncloud1046432uncloud
undead82711902undead
unfold10179702unfold
unfond10149112unfond
unhood1039232unhood
unlade72714152unl_ade
unlaid7311752unlaid
unlay84613702unl_ay
unleads8228622unleads
unled64021072unl_ed
unloaded1049532unloaded
unloader936642unloader
unlobed10219742unlobed
unlock1248532unlock
unloved112310532unloved
unmold9148312unmold
unread73412672unread
unsold71410512unsold
untold7149682untold
uploads10266502uploads
vanload1144702vanload
abroad9310943abroad
afloat9315153afloat
allod64418383allo_d
aloud65018073_aloud
anlas55626933anl_as
anoa45634473an_oa_
anoas57226493an_oas
armload1044293armload
ballad94315323ballad
bloat75229923_bloat
blond85618373_blond
blood85319523_blood
broad84817693_broad
buncoed12378443buncoed
bunkoed14356663bunkoed
busloads1144153busloads
byroad1236623byroad
carload1039783carload
clad76225823_cl_ad
cloak115214013_cloak
clod76124613_clo_d
cloud86716423_cloud
colead94114643colead
delead84112343delead
download1343833download
enfold10137613enfold
ennead736253ennead
euploid1038963euploid
float85928573_float
flood95215603_flood
fungoid1245253fungoid
glad65624013_gl_ad
gloam86015943_gloam
gloat65427683_gloat
goad66830983__goad
gunboat1047363gunboat
gunlock1444563gunlock
haloed104717603haloed
haloid104317763haloid
hulloa95011183hulloa_
hulloaed12105803hulloaed
hulloas103911913hulloas
hulloed11369793hulloed
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
naiad6313403_naiad
nicad8312613_nicad
nod47549563_n_o_d
nomad86016183_nomad
nullah9388143nullah
nulled74318273nulled
offload1443203offload
ogdoad943523ogdoad
onboard1046503onboard
onlay84212943onl_ay
onloaded1044743onloaded
outlead83311103outlead
payload1336403payload
plead85818463_plead
plod76723273_plo_d
preload1049813preload
reloads8911313reloads
reloan6415693reloan
road56332113__road
salad65321833sal_ad
siloed74615303siloed
sloid64619713_sloid
slojd13378843_slojd
sloyd9409683_sloyd
snood64616163sn_ood
soloed74515743soloed
sunland837473sunland
toad55830183__toad
uhlan849113uhl_an
ulan46527393u_l_an
ulna46317333u_lna_
ulnae55214573u_lnae
ulnar56013983u_lnar
ulnas55716533u_lnas
ulpan7310123u_lpan
ulva75412693u_lva_
ulvas84511503u_lvas
unaged83916423unaged
unai44824783un__ai
unau43924153un__au
unawed103914903unawed
unaxed144113093unaxed
unban72114333un_ban
unbar71913613un_bar
unbear889163unbear
unbend9269773unbend
unbid83214643un_bid
unbind93011433unbind
unblock1545793unblock
unbloody1482413unbloody
unbolt83013893unbolt
unboned103014223unboned
unborn83310813unborn
unbound10158393unbound
unbowed132610243unbowed
unbox1438753unbo_x
unboxed17249573unboxed
unbraid1037183unbraid
unbred92613303unbred
uncap9312283un_cap
uncia75015163uncia_
unciae83215313unciae
uncial83715223uncial
unclean946973unclean
unclear936573unclear
uncloaked1635653uncloaked
uncloaks1444133uncloaks
unclog956603unclo_g
unclogs1036803unclogs
unclose91111643unclose
unclosed111010503unclosed
unclouds1144883unclouds
uncloudy1443013uncloudy
uncloyed1487343uncloyed
unco66021403unco__
uncoated11314963uncoated
uncock1438563uncock
uncoded11312743uncoded
uncoil8811853uncoil
uncool8610113uncool
uncork1239043uncork
uncos74117033unco_s
uncoy104111413unco_y
underload1146373underload
undid72415363un_did
undo55620153undo__
undock1337703undock
undoer73113043undoer
undoes73917403undoes
undone7914253undone
undraw1037813undraw
undyed1138143undyed
unfed94614223un_fed
unfolds11146803unfolds
unfound11127393unfound
ungird887973ungird
unglove1136103unglove
ungloved1335603ungloved
unglued937303unglued
ungot61718063ungo_t
ungual738183ungual
unguard955093unguard
unhand10410383unhand
unhat81119263un_hat
unheard1136943unheard
unholy1238163unholy
unhoods1137503unhoods
unhook1347523unhook
unhoped13249353unhoped
unilobed1136393unilobed
union54519793unio_n
unions64216753unions
unipod946853unipod
unitard838003unitard
united74421543united
unjam1448723un_jam
unkend11309223unkend
unkind113310573unkind
unlace82215173unlace
unlaced102913733unlaced
unladed92614373unladed
unladen8248653unl_aden
unlades82612833unl_ades
unlash938793unlash
unlays93810493unlays
unleaded10411333unleaded
unlearn735953unlearn
unleased9310713unleased
unleash1034963unleash
unless62413073unless
unlet54133333unl_et
unlike102614063unlike
unliked122411283unliked
unlined82515803unlined
unlink104011013unlink
unlit55025463unl_it
unlive92712333unlive
unlived112511373unlived
unloaders1044403unloaders
unloading1137193unloading
unlocated1238383unlocated
unlocked15268383unlocked
unlocks1337063unlocks
unloose797863unloose
unloosed9117523unloosed
unmade92911063un_made
unman72715423un_man
unmolds10135743unmolds
unmoor836313unmoor
unmoral948693unmoral
unmoved13248903unmoved
unmown11296093unmown
unnoted8311363unnoted
unpaid939473unpaid
unplowed1436353unplowed
unposed10711903unposed
unready11215943unready
unreal64414453unreal
unrobe82611673unrobe
unrobed102711213unrobed
unroll61210073unroll
unroof9410193unroof
unroot6315553unroot
unroped102812103unroped
unround8138503unround
unrove92511683unrove
unsaid7411833unsaid
unsay83212843un_say
unseal63315473unseal
unseam83313143unseam
unseat64221023unseat
unshed10313773unshed
unshod1067603unshod
unsnag736393unsnag
unsnap836203unsnap
unsoaked1338853unsoaked
unsolid8138373unsolid
unsound8158433unsound
unsowed112511053unsowed
unsown9328433unsown
untied73720813untied
unto45824283unto__
untorn63012343untorn
untoward1243193untoward
untread857413untread
untrod769853untrod
unused72012883unused
unvocal1245233unvocal
unwed94114873un_wed
unwind102610543unwind
unwon84512343unwo_n
unwooed11229773unwooed
unworn93411333unworn
unwound11126613unwound
unwove12238883unwove
unwrap11126323unwrap
unyoke1367293unyoke
unyoked1567123unyoked
unzoned172310653unzoned
upfold12124953upfold
uphoard1344573uphoard
uphold12126903uphold
upland938863upland
upleap10106843upleap
uploaded1234533uploaded
uproar8106933uproar
upsoar8105683upsoar
vanloads1264163vanloads
woad85523943__woad
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.373479064.3
2DLD Change Limit1127163095.50020493.8
3Display Results3093090.0963218.8
 (SQL Overall)1786913095.96929936.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.