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

348 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
dawdler1235679(None) 
dandler94414271dandler
dawdle11399501dawdle_
dawdled13376721dawdled
dawdlers13375671dawdlers
dawdles12379161dawdles
bawdier13378202bawdier
bawler114315052baw_ler
candler103516592candler
dabbler124012152dabbler
daddle94214282daddle_
daddled113810742daddled
daddles104213802daddles
dander811222992dand_er
dandier93714572dandier
dandle84218092dandle_
dandled103313542dandled
dandlers103912052dandlers
dandles94218532dandles
dangler96912812dangler
dazzler1634712dazzler
diddler103511512diddler
doodler93310152doodler
dowdier12328572dowdier
drawler11338592draw_ler
handler113516162handler
ladler74314932la_dler
landler84113202landler
paddler113711552paddler
saddler93811962saddler
waddler124010792waddler
abler75624313_a_bler
adder75419593_a_dder
addle74318353_addle_
addled94112523_addled
addles84216603_addles
aider65431133_aid_er
alder65421913_ald_er
ambler104916453_ambler
ampler104313303_ampler
angler74017863_angler
antler64615553_antler
ashler9459973_ashler
aulder7511453_aulder
babbler104012823babbler
badder103817513ba_dder
badger105415083ba_dger
baffler15418113baffler
bailer85425253ba_iler
balder95318863bald_er
baler75635273ba__ler
baller83825203ba_ller
bander93928223band_er
battler94113383battler
bawdies134613393bawdies
bawled124415693baw_led
bawlers124412733baw_lers
boodler103312003boodler
bowlder13407483bowlder
bowler114217313bow_ler
brawler124310233braw_ler
bridler103811073bridler
bundler104011723bundler
cabler104519173ca_bler
cackler153812573cackler
cadger105013913ca_dger
cajoler16398393cajoler
caller85125483ca_ller
candle94321483candle_
candled113815743candled
candlers114214103candlers
candles104422343candles
carder94524183card_er
caroler93816753caroler
caudle93912913caudle_
caudles103912813caudles
caviler1249063caviler
chandler14358373chandler
coddler113710833coddler
cradler102910513cradler
crawler123510463craw_ler
cuddler113810743cuddler
curdler103511563curdler
dabber114816963da_bber
dabble114515193dabble_
dabbled133712073dabbled
dabblers13379363dabblers
dabbles124514773dabbles
dabster1036703dabster
dacker134920753da_cker
daddies103414943daddies
dadoed9449903da_doed
dadoes85616533da_does
daffier1457833daffier
dafter104813343da_fter
dagger95017303da_gger
daggle93711903daggle_
daggled11329463daggled
daggles103611913daggles
daiker115113033da_iker
dale55643983da__le_
dales66439743da__les
dalles74222063da_lles
dallier84215373dallier
damager1157983damager
dammer114317933da_mmer
damner95213433da_mner
damper114117753da_mper
dancer94817613da_ncer
danders93921183dand_ers
dandies94121443dandies
danger83722823da_nger
dangle84119303dangle_
dangled104013153dangled
danglers103610593danglers
dangles93618423dangles
danglier1056753danglier
danker114319663da_nker
dapper114016633da_pper
dapple1138853dapple_
dappled1336393dappled
dapples1238993dapples
darer65230793da__rer
darker114718693da_rker
darkle113813943darkle_
darkled13378723darkled
darkles124011933darkles
darklier1335013darklier
darner74017303da_rner
darter75320363da_rter
dartle73714833dartle_
dartled9409853dartled
dartles84014133dartles
dasher104318983da_sher
dashier114311183dashier
dater65332313da__ter
dauber94112013da_uber
daubier1037103daubier
daunder9348893daunder
daunter83811753daunter
dawdling14236373dawdling
dawed106222813daw__ed
dawen95413723daw__en
dawned113912093daw_ned
dawted11489683daw_ted
dawtie103011093dawtie_
dawties113312703dawties
dazzle1536853dazzle_
dazzled1735033dazzled
dazzlers1733233dazzlers
dazzles1636413dazzles
deader84220473dead_er
deadlier1036863deadlier
dealer74122143d_ealer
deedier93011593deedier
defiler113911883defiler
dewater112912423dewater
dewier104013463dew_ier
dialer74315433d_ialer
dialler848813dialler
dibbler124510283dibbler
diddle94915213diddle_
diddled114212053diddled
diddlers11359153diddlers
diddles103915073diddles
diddley13388103diddley
dindle84417223dindle_
dindled104412723dindled
dindles93817243dindles
dodder94712913d_odder
dodger95817053d_odger
doodle83212853doodle_
doodled10369463doodled
doodlers10338843doodlers
doodles93614163doodles
doubler103110083doubler
dowager1245803dowager
dowdies123412733dowdies
doweled12269773doweled
dower95027703dow__er
downer104414923dow_ner
downier11299703downier
dowser104716083dow_ser
drawer104711363draw__er
drawled12368343draw_led
drawlers12307313draw_lers
drawlier12225253drawlier
dredger10347453dredger
driller84311883driller
droller84110283droller
drudger10328323drudger
dueler74213683d_ueler
dueller8329833dueller
duller74017703d_uller
dwarfer1433683dwarfer
dweller11297273dweller
fabler116115813fa_bler
faddier1237783faddier
fader94421513fa_d_er
faller94621233fa_ller
fawner125910463faw_ner
fawnier13296363fawnier
fiddler12309953fiddler
fondler11348883fondler
fowler123712583fow_ler
gabbler124013303gabbler
gadder93714713ga_dder
gambler123612683gambler
gander84322763gand_er
gaoler73913573ga_oler
garbler104012563garbler
gargler93710263gargler
gaudier938453gaudier
gawker14559353gaw_ker
gawkier15326523gawkier
gawper12499693gaw_per
girdler9227313girdler
hackler163512353hackler
haggler12328933haggler
hailer94720343ha_iler
haler85033523ha__ler
hander104526433hand_er
handier113817443handier
handle104219293handle_
handled124114533handled
handlers124014143handlers
handles114020653handles
harder105022403hard_er
hardier114721543hardier
hauler95015123ha_uler
hawker164812663haw_ker
hawser125910843haw_ser
howler123514313how_ler
huddler12379423huddler
hurdler113610003hurdler
idler65015663__idler
jailer134316683ja_iler
jangler153811833jangler
jeweler1735053jeweler
kindler12309983kindler
labeler92310183labeler
ladder84617623la_dder
lader65633723la_d_er
ladle66320443la_dle_
ladled85013483la_dled
ladlers84613573la_dlers
ladles74619543la_dles
lander74028483land_er
landlers94312833landlers
larder73720973lard_er
lardier83518343lardier
lauder73815013laud_er
lawyer12386973law_yer
lewder10479613lewd_er
madder103515593ma_dder
mailer84724183ma_iler
mangler103215643mangler
marbler113511673marbler
mauler84416713ma_uler
meddler11319953meddler
mewler113510233mew_ler
middler112712273middler
muddler113411623muddler
nailer64119363na_iler
needler8388893needler
padder103415493pa_dder
paddle104615143paddle_
paddled123612023paddled
paddlers12329153paddlers
paddles113515643paddles
padle84522343pa_dle_
padles95221123pa_dles
paler75436933pa__ler
pander93725523pand_er
pardner10239473pardner
pawer104422973paw__er
pawkier16236613pawkier
pawner114212923paw_ner
peddler113210493peddler
pedler93614623_pedler
piddler112911523piddler
powder123611903powd_er
puddler112910753puddler
rabbler113514093rabbler
raddle84816173raddle_
raddled103812223raddled
raddles93615703raddles
raffler13339223raffler
raider74318743raid_er
railer64524933ra_iler
rambler113313263rambler
randier83618473randier
rattler74012743rattler
raveler104212463raveler
rawer84623733raw__er
riddler93411263riddler
rowdier11348593rowdier
sadder82916973sa_dder
saddle83915493saddle_
saddled103112033saddled
saddlers10289753saddlers
saddlery13274913saddlery
saddles95415743saddles
sailer63526103sa_iler
sampler113212013sampler
sander74828533sand_er
sandier84017843sandier
sawer85026213saw__er
sawyer12438043saw_yer
sidler74716963_sidler
tackler134013323tackler
tailer63823733ta_iler
taler56034863ta__ler
taller63721963ta_ller
tangler83515073tangler
tardier859719993tardier
tattler73112213tattler
tawdrier12133433tawdrier
tawer85223443taw__er
tawnier10318463tawnier
tiddler93110003tiddler
toddler9379043toddler
trawler104011903traw_ler
twaddler13314643twaddler
wabbler143511923wabbler
wadder114215483wa_dder
waddle114715303waddle_
waddled133611643waddled
waddlers13298333waddlers
waddles124314843waddles
wader95325363wa_d_er
waffler16377783waffler
wailer93720323wa_iler
waler84229263__waler
wander104423713wand_er
wandle105316663wandle_
wangler113312653wangler
warbler123211463warbler
warder104020273ward_er
warsler10289893warsler
wawled133811703waw_led
yarder103813973yard_er
yawled13459983yaw_led
yawner12428473yaw_ner
yawper14437953yaw_per
yodler10389943_yodler
yowler123310043yow_ler
zander163417113zand_er

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 Limit1340273486.26621389.6
3Display Results3483480.1232829.3
 (SQL Overall)1786913486.79526297.4
 
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.