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

385 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
wielder1119767(None) 
fielder11217411fielder
welder102914411w_elder
wielded12216681wielded
wielders12196611wielders
wieldier1234281wieldier
wilder103616471wi_lder
yielder11175111yielder
bielded11226712bielded
elder64020022__elder
fielded12206812fielded
fielders12156772fielders
gelder84613712_gelder
gilder84415532gi_lder
lieder74912322lie_der
melder93915812_melder
milder93818452mi_lder
shielder1235182shielder
wedder113612302w_edder
weeder103315512w_eeder
weirder1144922weirder
welded114013382w_elded
welders113313412w_elders
weldor10317652w_eldor
welter93417382w_elter
widder112913972wi_dder
wider94826352wi__der
wield95213912wield__
wields10469622wield_s
wieldy13476182wield_y
wiener94513542wie_ner
wifelier1434852wifelier
wilded113714502wi_lded
wilders113513502wi_lders
wilier93217072wi_lier
willer94021062wi_ller
winder104025262wi_nder
wiselier1137362wiselier
yielded12184712yielded
yielders12164742yielders
aider65431133ai__der
alder65421913__alder
amender10349613amender
atelier7311623atelier
aulder7511453_aulder
balder95318863_balder
beader94623793_beader
bedder104215793_bedder
belier84423563_belier
belter84720963_belter
bender95223303_bender
bewilder1434133bewi_lder
bidder104114863bi_dder
bider85728373bi__der
bield84614653bield__
bields94110003bield_s
bilker124913443bi_lker
biller84923483bi_ller
binder94422873bi_nder
birder94915493bi_rder
birler85715083birl_er
bleeder10359643bleeder
blender104613843blender
bolder94820933_bolder
boulder103411343boulder
bowlder13407483bowlder
breeder103210043breeder
builder1037573builder
ceder85322243_ce_der
ceiler84013963ceil_er
cheder125113493che_der
cider84723313ci__der
cinder94119123ci_nder
colder95121853_colder
deader84220473_deader
deluder9168333_deluder
delver104913493_delver
dialer74315433dial_er
dialler848813dialler
diddler103511513diddler
diester83013683diester
dieter73516773die_ter
diether1147443diether
divider12278953divider
dueler74213683duel_er
dueller8329833dueller
dweller11297273dweller
eelier64216463_eelier
eider64624743__eider
elders74817303__elders
eluder73712213__eluder
elver85216243__elver
emender10649843emender
ender64325863__ender
feeder103513843_feeder
feeler93215173feel_er
feller94419553_feller
fender103718723_fender
fiddler12309953fiddler
field95015323field__
fields104211043field_s
fiercer12356953fiercer
fierier103511193fierier
filer85433003fi_l_er
filler94623623fi_ller
filmer114112403fi_lmer
filter94517633fi_lter
finder104020233fi_nder
folder104317543_folder
fueler94313933fuel_er
fueller10279963fueller
gelded94512113_gelded
gelders93812573_gelders
gender83517933_gender
gilded94413223gi_lded
gilders94212463gi_lders
giller74519733gi_ller
girder84312063gi_rder
girdler9227313girdler
girlier8289523girlier
golder84417603_golder
guilder945913guilder
header104422543_header
heder95623643_he_der
heeder104216043_heeder
heeler93917313heel_er
heller93322513_heller
helper114313093_helper
herder104516463_herder
hider95024083hi__der
hiller94421633hi_ller
hillier103413963hillier
hinder104120063hi_nder
holder104619653_holder
idler65015663_idl_er
iller54821293_i_ller
infielder1343173infielder
inlier63615363_inlier
jilter133512513ji_lter
kelter103214383_kelter
kidder123811103ki_dder
kiester11329973kiester
killdee1266223killdee
killdeer1362943killdeer
killer104917953ki_ller
kilter103714343ki_lter
kinder113716843ki_nder
kindler12309983kindler
kneader1275893kneader
leader74824653_leader
lender73921273_lender
lewder10479613_lewder
libeler9219003libel_er
libeller10297433libeller
liefer9529573lie_fer
liever94611863lie_ver
likelier1235283likelier
livelier1136873livelier
melded104714713_melded
melders103213913_melders
melter83520113_melter
mender93520793_mender
middler112712273middler
milded104416153mi_lded
milden94113153mi_lden
mildew12319043mi_ldew
miler75733063mi_l_er
milker124814323mi_lker
miller84625413mi_ller
millier93716703millier
milter84921233mi_lter
minder94822503mi_nder
molder93819273_molder
moulder10389803moulder
needer73614953_needer
needler8388893needler
oiler54628283oi_l_er
oilier64417233oi_lier
older65121173__older
pedler93614623_pedler
peeler83517383peel_er
pelter83321623_pelter
piddler112911523piddler
piecer105213083pie_cer
piercer11337773piercer
pilfer1139163pi_lfer
pinder94523453pi_nder
pleader103511753pleader
polder94019253_polder
preluder1135733preluder
queller16289293queller
reader73628293_reader
redder83918143_redder
reeler63822573reel_er
relier65826183_relier
render74024143_render
ridder84015143ri_dder
riddler93411263riddler
rider65231303ri__der
riever94811653rie_ver
rifler94014263rifl_er
scolder103210343scolder
seder64826763_se_der
seeder74320773_seeder
seller63824603_seller
sender73824413_sender
shedder12339323shedder
sheller103515893sheller
shelter103214963shelter
shelver134211063shelver
shielded1334393shielded
shielders1334763shielders
sidler74716963sidl_er
siller64026063si_ller
sillier74017593sillier
silver93815813si_lver
skelter113610003skelter
sledder9399203sledder
slender83413593slender
smeller94212793smeller
smelter93311913smelter
smolder10327753smolder
sneller73512853sneller
solder73921343_solder
speeder103811073speeder
speller95415153speller
spelter94113703spelter
spender103713693spender
spieler93111233spiel_er
svelter10359673svelter
sweller103012473sweller
swelter103711173swelter
swiller103211663swi_ller
swindler12257723swindler
swirlier1135213swirlier
tedder83312163_tedder
telfer9379893_telfer
teller63519823_teller
tender74121843_tender
tiddler93110003tiddler
tilde65017343ti_lde_
tildes74513963ti_ldes
tiler56131023ti_l_er
tiller64222543ti_ller
tilter63417693ti_lter
timelier1036713timelier
timider1037093timider
tinder73821803ti_nder
tireder837703tireder
treader84113833treader
twiddler13244873twiddler
twirler10285203twirl_er
twirlier1133513twirlier
unwieldier1451653unwieldier
veiler93814353veil_er
vender103418423_vender
viewer1237213vie_wer
viewier1334983viewier
viler86324163vi_l_er
vivider14265623vivider
wadder114215483w_adder
waddler124010793waddler
wader95325363w__ader
wailer93720323wail_er
waler84229263w_al_er
walker133913993w_alker
wander104423713w_ander
warder104020273w_arder
weaker134015443w_eaker
weaner93816773w_eaner
wearer94319403w_earer
weaver123916613w_eaver
weber10313523w_e_ber
wedded123811843w_edded
wedders123610723w_edders
wedel94513963w_e_del
weeded113914873w_eeded
weeders113412933w_eeders
weedier113810623weedier
weenier103210803weenier
weeper114313303w_eeper
weepier12319273weepier
weer75535093w_e__er
weever123811443w_eever
weigher14136343weigher
weiner94214133w_einer
weirded1234513weirded
welcher15319393w_elcher
weld84727733w_eld__
weldors11238003w_eldors
welds94719163w_eld_s
welldoer1243473welldoer
welled103820213w_elled
welsher13377443w_elsher
welted103715823w_elted
welters103516063w_elters
wended113616153w_ended
wester94222893w_ester
wether123315393w_ether
wetter93919443w_etter
whaler124611973whal_er
wheedler1543543wheedler
wheeler13298773wheeler
wheezer22296673wheezer
whelkier1833253whelkier
whelmed16375153whelmed
whelped16355633whelped
whether16346623whether
whetter13348803whetter
whirler13307603whirl_er
whirlier14175293whirlier
wickeder1843983wickeder
wicker154518673wi_cker
widders123512273wi_dders
widdle113814843widdle_
widdled133511233widdled
widdles123514343widdles
wide85235413wi__de_
widen94717973wi__den
widener11318693widener
wides94832823wi__des
widower1435343widower
wieldiest1334803wieldiest
wielding13286863wielding
wieners103212483wie_ners
wienie9229973wienie_
wienies102213683wienies
wiftier13297733wiftier
wiggier12418863wiggier
wiggler123110763wiggler
wigglier1354453wigglier
wiglet105519153wigl_et
wild85126513wi_ld__
wildered1336633wi_ldered
wildest113311273wi_ldest
wildly13328123wi_ldly
wilds94818203wi_ld_s
wile75944373wi_l_e_
wiled95231553wi_l_ed
wiles85437873wi_l_es
willed104722453wi_lled
willers103517913wi_llers
willet95124833wi_llet
willie94116453willie_
willied114611563willied
willies103920153willies
willower14127453willower
wilted103915713wi_lted
wimpier14248053wimpier
wincer115018193wi_ncer
wincher153410653wincher
winded114918213wi_nded
winders113721263wi_nders
windier113412163windier
windle104617953windle_
windled123713483windled
windles113518493windles
winger104125443wi_nger
wingier113413283wingier
winier94522453wi_nier
winker134220293wi_nker
winner94219933wi_nner
winter94222803wi_nter
wiper105421293wi__per
wirer85124953wi__rer
wirier94215553wi_rier
wiser85522803wi__ser
wisher123617063wi_sher
wispier12249403wispier
wither124321353wi_ther
withier132910493withier
wittier103910823wittier
wiver115924513wi__ver
wolfer12429983w_olfer
wolver12419713w_olver
wonder103617813w_onder
wooler93615873wool_er
woolier103612353woolier
wreaker143610043wreaker
wrecker16367603wrecker
wrester102812413wrester
yeller94214513_yeller
yelper11458783_yelper
yield9519693yield__
yields10466843yield_s

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 Filter1786911340270.453394461.4
2DLD Change Limit1340273856.53020524.8
3Display Results3853850.1402750.0
 (SQL Overall)1786913857.12325086.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.