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

269 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
yielder1117511(None) 
fielder11217411fielder
wielder11197671wielder
yielded12184711yielded
yielders12164741yielders
bielded11226712bielded
elder64020022__elder
fielded12206812fielded
fielders12156772fielders
gelder84613712_gelder
gilder84415532gi_lder
lieder74912322lie_der
melder93915812_melder
milder93818452mi_lder
shielder1235182shielder
welder102914412_welder
wielded12216682wielded
wielders12196612wielders
wieldier1234282wieldier
wilder103616472wi_lder
yeller94214512y_eller
yelper11458782y_elper
yield9519692yield__
yields10466842yield_s
aider65431143ai__der
alder65421913__alder
amender10349613amender
atelier7311643atelier
aulder7511453_aulder
balder95318863_balder
beader94623793_beader
bedder104215793_bedder
belier84423563_belier
belter84720963_belter
bender95223303_bender
bidder104114863bi_dder
bider85728383bi__der
bield84614653bield__
bields94110003bield_s
bilker124913443bi_lker
biller84923483bi_ller
binder94422873bi_nder
birder94915493bi_rder
birler85715083birl_er
bleeder10359643bleeder
blender104613853blender
bolder94820933_bolder
boulder103411343boulder
bowlder13407483bowlder
breeder103210043breeder
builder1037573builder
ceder85322243_ce_der
ceiler84013963ceil_er
cheder125113493che_der
cider84723323ci__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
eider64624753__eider
elders74817303__elders
eluder73712223__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
heeler93917323heel_er
heller93322513_heller
helper114313093_helper
herder104516463_herder
hider95024093hi__der
hiller94421633hi_ller
hillier103413963hillier
hinder104120063hi_nder
holder104619653_holder
idler65015663_idl_er
iller54821293_i_ller
infielder1343173infielder
inlier63615363_inlier
jilter133512513ji_lter
kelter103214383_kelter
kidder123811113ki_dder
kiester11329973kiester
killdee1266223killdee
killdeer1362943killdeer
killer104917953ki_ller
kilter103714343ki_lter
kinder113716853ki_nder
kindler12309983kindler
kneader1275893kneader
leader74824653_leader
lender73921283_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
pinder94523463pi_nder
pleader103511763pleader
polder94019253_polder
preluder1135733preluder
queller16289293queller
reader73628293_reader
redder83918143_redder
reeler63822573reel_er
relier65826183_relier
render74024143_render
ridder84015143ri_dder
riddler93411263riddler
rider65231313ri__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
slender83413603slender
smeller94212793smeller
smelter93311913smelter
smolder10327753smolder
sneller73512853sneller
solder73921343_solder
speeder103811073speeder
speller95415153speller
spelter94113703spelter
spender103713693spender
spieler93111233spiel_er
svelter10359673svelter
sweller103012473sweller
swelter103711173swelter
tedder83312163_tedder
telfer9379903_telfer
teller63519833_teller
tender74121843_tender
tiddler93110003tiddler
tilde65017353ti_lde_
tildes74513963ti_ldes
tiler56131023ti_l_er
tiller64222543ti_ller
tilter63417693ti_lter
timelier1036713timelier
timider1037093timider
tinder73821803ti_nder
tireder837703tireder
treader84113833treader
veiler93814353veil_er
vender103418423_vender
viewer1237213vie_wer
viewier1334983viewier
viler86324163vi_l_er
vivider14265623vivider
wedder113612303_wedder
weeder103315513_weeder
weirder1144923weirder
welded114013383_welded
welders113313413_welders
weldor10317653_weldor
welter93417383_welter
widder112913973wi_dder
wider94826363wi__der
wield95213913wield__
wields10469623wield_s
wieldy13476183wield_y
wiener94513543wie_ner
wifelier1434853wifelier
wilded113714503wi_lded
wilders113513503wi_lders
wilier93217073wi_lier
willer94021063wi_ller
winder104025263wi_nder
wiselier1137363wiselier
yarder103813973y_arder
yeld811423873y_eld__
yelled104116253y_elled
yellers103912953y_ellers
yelped12439363y_elped
yelpers12348203y_elpers
yester93417983y_ester
yielding13205033yielding
yodeler1136343yodel_er
yodeller1244853yodeller
yodler10389943yodl_er
yonder103214133y_onder
yowler123310043yowl_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.403443402.0
2DLD Change Limit1340272696.17321711.8
3Display Results2692690.0932892.5
 (SQL Overall)1786912696.66926794.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.