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

293 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
shields1153804(None) 
chields13507481chields
shield106212971shield_
shiels95418921shiel_s
bields94110002_bields
chield124610212chield_
chiels115115932chiel_s
fields104211042_fields
sheds96122702sh_e_ds
sheilas1059402sheilas
shells94319522sh_ells
shends105313772sh_ends
sherds105614722sh_erds
shied96125492shie_d_
shiel811023772shiel__
shielded1334392shielded
shielder1235182shielder
shielders1334762shielders
shiers94921752shie_rs
shies86136552shie__s
shills94519612shi_lls
shreds105613052shre_ds
silds65520522s_i_lds
spiels85317952spiel_s
wields10469622_wields
yields10466842_yields
afield1035953afield_
aholds10469483ah_olds
ariels65119373ariel_s
bield84614653_bield_
builds9378493bui_lds
bushvelds1841203bushvelds
chelas113817203ch_elas
chicles143512503chicles
chiefs14509653chie_fs
chiel104918973chiel__
child114516223chi_ld_
childe124711213chi_lde
childes134211273chi_ldes
chiles115425303chi_les
chilis115517873chi_lis
chillis124411603chillis
chills114717703chi_lls
chimlas1437453chimlas
chisels12219103chisel_s
elds56324853___elds
field95015323_field_
fiends104110293_fiends
fjelds17414473_fjelds
friends11396743friends
gelds75118343__gelds
ghiblis1353343ghiblis
gilds75417523_gi_lds
guilds8388353gui_lds
heads95127113_h_eads
heeds95420423_h_eeds
heels85625533_heel_s
heils85222193_heil_s
held85330403_h_eld_
hells85032043_h_ells
helms105619463_h_elms
helos84928063_h_elos
helps105219343_h_elps
herds96424683_h_erds
hied85434043_hie_d_
hies74842833_hie__s
hillos94618893_hillos
hills85431353_hi_lls
hilts86924413_hi_lts
hilus84817643_hi_lus
hinds96721473_hi_nds
holds94623243_h_olds
infields1244013infields
melds84822383__melds
milds86422053_mi_lds
misfields15223653misfields
oriels64914623oriel_s
phials1158873phial_s
rewelds11457413rewelds
riels55121333_riel_s
saids65328853sai__ds
sailed74327763sailed_
sailers73822323sailers
sails55738103sai_l_s
saiyids11174893saiyids
samiels939763samiel_s
sayeds10469253saye_ds
scalds94813693s_calds
scends95213003s_cends
scillas9310473scillas
scolds95011233s_colds
screeds106210293screeds
seeds64330063s__eeds
seels55632823s_eel_s
seidels838393seidel_s
selfs85220243s__elfs
sells55134433s__ells
sels46345983s__el_s
sends65528243s__ends
shads95124483sh__ads
shairds11216263shairds
shaled105023953shaled_
shales94731253sh_ales
shards104319173sh_ards
shauls94913113shaul_s
shawls125411973shawl_s
sheafs124912883sh_eafs
sheals94420643sh_eals
shears93820903sh_ears
sheas86331793sh_e_as
shed86536153sh_e_d_
sheens95116993sh_eens
sheers94322403sh_eers
sheets93918503sh_eets
sheeves133911953sheeves
sheikhs17233993sheikhs
sheiks132510013sh_eiks
sheila969843sheil_a
shekels1436043shekel_s
shelf115221113sh_el_f
shell84424123sh_el_l
shelly124414473sh_elly
shelta93111793sh_elta
sheltas10279673sh_eltas
shelty124011553sh_elty
shelve124012763sh_elve
shelves134112093sh_elves
shelvy15377863sh_elvy
shend94719973sh_end_
sheols94614163sh_eols
sheqels1934753sheqel_s
sherd96321153sh_erd_
shes75734353sh_e__s
shews115924713sh_e_ws
shibahs15275643shibahs
shielding1434553shielding
shieling123512403shieling
shielings13237123shielings
shier85428943shie__r
shiest95821533shie_st
shifts124412943shi_fts
shigella1243063shigella
shigellas1343143shigellas
shikars1436183shikars
shiksas1484643shiksas
shikses14116573shikses
shill85325333shi_l_l
shilled113313623shilled
shily115222013shi_l_y
shims104422553shi__ms
shindy13449323shi_ndy
shindys14314133shindys
shined104620783shined_
shiners104015943shiners
shines95028913shi_nes
shingles123111113shingles
shins85131043shi__ns
shiplap1444513shiplap
shiplaps1544363shiplaps
shipless13277693shipless
shiploads1543813shiploads
ships105123773shi__ps
shires95225573shi_res
shirks134814123shi_rks
shirrs94413173shi_rrs
shirts94918343shi_rts
shists96515113shi_sts
shitheads1645043shitheads
shitless11249243shitless
shitlist1148723shitlist
shitloads1393503shitloads
shits84731173shi__ts
shivahs16375723shivahs
shivas124512413shi_vas
shivers133714833shivers
shives124921413shi_ves
shivs115018803shi__vs
shlepps14394833shlepps
shleps114710333shle_ps
shmears1277073shmears
shoals94215793shoal_s
shoed95723013shoe_d_
shoeless1137803shoeless
shoers94518333shoe_rs
shoes85429663shoe__s
shools94919013shool_s
shorls94516203shorl_s
should1038033should_
shouldst1243393shouldst
shovels13378393shovel_s
shred98125613shre_d_
shrewd136810783shrewd_
shrews129313923shre_ws
shrieks14377673shrie_ks
shrieves14297093shrieves
shrills10389933shrills
shrivels14376443shrivel_s
shrouds1136023shrouds
shtetls1034583shtetls
shuls85319713sh_ul_s
shyers124712203shye_rs
sialids839723s_ialids
sials54227243s_ial_s
sidles74721153s_idles
sieges73816833s_ieges
sieurs659043s_ieurs
sieves93216003s_ieves
siglos7311473s_iglos
sild55030583s_i_ld_
silks94620683s_i_lks
sills55135993s_i_lls
silos56029433s_i_los
silts55330823s_i_lts
skalds11437833s_kalds
skells105013783s_kells
skelms12368023s_kelms
skelps12407923s_kelps
skids104615333ski__ds
skied104417753skie_d_
skiers104713703skie_rs
skies95026833skie__s
skills104313923ski_lls
skirls10449823skirl_s
sleds64418853s_le_ds
slieves10378963slieves
smells83914743s_mells
smelts85412773s_melts
smiled93716433smiled_
smilers94113853smilers
smiles84522293smi_les
smileys12336323smileys
sneds65715353s_ne_ds
snells64614203s_nells
snivels10336903snivel_s
soiled73822473soiled_
soils55327983soi_l_s
sorels63921163sorel_s
speeds94316053s_peeds
speels85116393speel_s
speils84116223speil_s
spells84617683s_pells
spelts84614643s_pelts
spends94714473s_pends
spied85427713spie_d_
spiel74623913spiel__
spieled104811883spieled
spieler93111233spieler
spielers10319653spielers
spiers84421743spie_rs
spies76037623spie__s
spiled94621993spiled_
spiles84227913spi_les
spills84717463spi_lls
spinels94512443spinel_s
spreads1039763spreads
steads74116223s_teads
steeds73814883s_teeds
steels64117983steel_s
steles63725663s_teles
stied65723033stie_d_
sties55132983stie__s
stifles103013393stifles
stiles64328773sti_les
stills64118573sti_lls
stilts67915313sti_lts
stipels9418953stipel_s
stipends11304793stipends
subfields1543303subfields
swells93913983s_wells
swills94213363swi_lls
swiples12339643swiples
swirls94010133swirl_s
swivels13396773swivel_s
thieves1346903thieves
thills95515383thi_lls
thiols95112763thiol_s
thirds10438603thi_rds
thirls95012063thirl_s
threads11419953threads
velds95615583__velds
welds94719163__welds
wheels123811713wheel_s
whelks16367323wh_elks
whelms14377573wh_elms
whelps14437843wh_elps
whids125413983whi__ds
whiled134514133whiled_
whiles124418013whi_les
whirls124710533whirl_s
wield95213913_wield_
wieldy13476183_wieldy
wilds94818203_wi_lds
yield9519693_yield_

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 Limit1340272936.40620922.1
3Display Results2932930.1102663.6
 (SQL Overall)1786912936.92225814.9
 
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.