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

163 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
shielder123518(None) 
shielded1334391shielded
shielders1334761shielders
fielder11217412_fielder
shedder12339322sh_edder
sheller103515882sh_eller
shelter103214962sh_elter
shelver134211062sh_elver
shield106212972shield__
shields11538042shield_s
shoulder1234752shoulder
shredder1334402shredder
shrewder1534402shrewder
spieler93111232spiel_er
wielder11197672_wielder
yielder11175112_yielder
bielded11226713_bielded
builder1037573bui_lder
cheder125113493ch_e_der
chider125116053chi__der
chiefer1536863chie_fer
chield124610213chield__
chields13507483chield_s
childe124711213chi_lde_
childes134211273chi_ldes
chiller124112183chi_ller
chillier13328423chillier
chiseler1335903chisel_er
chiseller1443963chiseller
elder64020023___elder
fielded12206813_fielded
fielders12156773_fielders
gelder84613713__gelder
gilder84415533_gi_lder
guilder945913gui_lder
header104422543_h_eader
heder95623643_h_e_der
heeder104216043_h_eeder
heeler93917313_heel_er
heller93322513_h_eller
helper114313093_h_elper
herder104516463_h_erder
hider95024083_hi__der
hiller94421633_hi_ller
hillier103413963_hillier
hinder104120063_hi_nder
holder104619653_h_older
infielder1343173infielder
lieder74912323_lie_der
melder93915813__melder
milder93818453_mi_lder
philter12108213phi_lter
sailer63526103sai_l_er
schiller13296473schi_ller
scolder103210343s_colder
seceder10329573sece_der
seder64826763s__e_der
seeder74320773s__eeder
seller63824593s__eller
sender73824413s__ender
shader104218763sh__ader
shalier103116423sh_alier
shapelier1444463shapelier
shearer104414683sh_earer
shedded13419063sh_edded
shedders13267433sh_edders
sheenier11167423sheenier
sheer84726893sh_e__er
sheerer103813843sh_eerer
sheeter103814913sh_eeter
shelled113815083sh_elled
shellers112812573sh_ellers
shellier1138393shellier
shelters113412813sh_elters
shelve124012763sh_elve_
shelved14379933sh_elved
shelvers14388813sh_elvers
shelves134112093sh_elves
shelvier1464913sh_elvier
shewer124515113sh_e_wer
shicker163914823shi_cker
shied96125493shie_d__
shiel811023773shiel___
shielding1434553shielding
shieling123512403shieling
shiels95418923shiel__s
shier85428943shi___er
shifter132911083shi_fter
shiftier1436343shiftier
shikker13277023shi_kker
shilled113313623shi_lled
shimmer143310873shi_mmer
shiner93820873shi__ner
shingler12268633shingler
shinier104113143shi_nier
shipper143514043shi_pper
shirker143711343shi_rker
shirtier1137943shirtier
shittier1137313shittier
shiver124517373shi__ver
shiverer14186663shiverer
shoaler102610083shoal_er
shoalier1137073shoalier
shoulders1334233shoulders
shoveler14165583shovel_er
shoveller15174543shoveller
shredded1444063shredded
shredders1463713shredders
shrieker15265653shrie_ker
shriekier1652963shriekier
shriller1136823shriller
shudder12297323sh_udder
sidler74716963s_idl_er
siller64026063s_i_ller
sillier74017593s_illier
silver93815813s_i_lver
skelter113610003s_kelter
skidder1365733ski_dder
sledder9399203s_ledder
slender83413593s_lender
slider73918363sli__der
smeller94212783s_meller
smelter93311913s_melter
smiler83916683smi_l_er
smolder10327753s_molder
smoulder1133443smoulder
sneller73512843s_neller
snider74413913sni__der
sniveler1155253snivel_er
sniveller1253703sniveller
solder73921343s__older
speeder103811073s_peeder
speller95415143s_peller
spelter94113703s_pelter
spender103713693s_pender
spider94516803spi__der
spieled104811883spiel_ed
spielers10319653spiel_ers
spiller92914333spi_ller
spindler11297983spindler
spreader1137483spreader
steelier839183steelier
stifler102911473stifl_er
stiller73414293sti_ller
stillier868823stillier
svelter10359673s_velter
sweller103012463s_weller
swelter103711173s_welter
swiller103211663swi_ller
swindler12257723swindler
swirlier1135213swirlier
threader1256733threader
welder102914413__welder
wheedler1543543wheedler
wheeler13298773wheel_er
whirler13307603whirl_er
whirlier14175293whirlier
wielded12216683_wielded
wielders12196613_wielders
wieldier1234283_wieldier
wilder103616473_wi_lder
yielded12184713_yielded
yielders12164743_yielders

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621636.47022590.7
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.95325699.8
 
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.