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

184 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
scareder113579(None) 
carder94524182_car_der
career85822242_care_er
scarcer113911372scar_cer
scared95227292scared__
scaredest1246632scaredest
scarer84524612scar__er
scarfer124511082scar_fer
scarier94017872scar_ier
scarper114814822scar_per
scarrier10298452scarrier
screwer124410072sc_rewer
acceder1235363ac_ceder
acrider1038623ac_rider
arider74717743__arider
ascared10399523ascared__
ascarides12346953ascarides
awarder1135893awar_der
boarder103910323boar_der
calender1138273_calender
caperer113013403_caperer
carded105424903_car_ded
carders104820353_car_ders
cared86050093_cared__
careen84119493_care_en
careener1039333_careener
careerer1038583_careerer
careers95218783_care_ers
carer74942333_car__er
caresser1038813_caresser
caroler93816753_caroler
carper104923633_car_per
carrier93619583_carrier
carter84932273_car_ter
carver114420153_car_ver
caterer92815943_caterer
ceder85322243_c__eder
cheder125113493_c_heder
corder94322883_cor_der
cruder95612383_c_ruder
curseder1145343_curseder
darneder1033983_darneder
discarder1346753discar_der
escalader1243233escalader
guarder936463guar_der
harder105022403_har_der
hoarder11329233hoar_der
larder73720973_lar_der
nakeder1254363_nakeder
parader103914863_parader
sacred94917103sacred__
sacredly1444473sacredly
sadder82916973s_a_dder
sander74828533s_a_nder
sardar73013173s_ar_dar
saree55044663s_are_e_
sarees65329943s_are_es
sarkier113413313s_arkier
sarode75317513s_arode_
sarodes84216143s_arodes
scabbier1435133scabbier
scalade10359263scalade_
scalades11258803scalades
scalded11409763sca_lded
scaled94822443scaled__
scalene9310773scalene_
scaler84321603sca__ler
scalier94316913sca_lier
scalper113912923sca_lper
scammer133611973sca_mmer
scamper134613163sca_mper
scamperer1544623scamperer
scamster1235303scamster
scanner94411813sca_nner
scanter94215183sca_nter
scantier10309983scantier
scaped115519553scaped__
scarce104013633scar_ce_
scare75334463scar__e_
scarehead1543803scarehead
scarers94618513scare_rs
scares85033003scar__es
scarey115016983scar__ey
scarfed134711183scar_fed
scarfers13408463scar_fers
scarifier1446653scarifier
scarlet91516943scar_let
scarped124314403scar_ped
scarpered1435113scarpered
scarpers124712513scar_pers
scarphed1635443scarphed
scarred104512633scar_red
scarted104816123scar_ted
scarves124511623scar_ves
scatter93815173sca_tter
scatterer11186293scatterer
scattier10267583scattier
scauper11379453sca_uper
scavenger1542193scavenger
schemer1477963sc_hemer
schmeer1475363schme_er
scolder103210343sc_older
scorcher15196783scorcher
scored94621133scored__
scorer84818263scor__er
scorner9259763scor_ner
scowder13286873sc_owder
scraper114513423sc_raper
scrapper1466973scrapper
scrawler1345893scrawler
screamer12267883sc_reamer
scree720031713sc_re_e_
screed95718933sc_re_ed
screeded1235643screeded
screeds106210293sc_reeds
screen85216023sc_re_en
screener1037573screener
screes85023973sc_re_es
screwed135710663sc_rewed
screwers13358063sc_rewers
screwier1346433sc_rewier
scriber113910973sc_riber
scurfier13267053scurfier
scurvier13255883scurvier
searcher13209103searcher
seared75232843seared__
searer65432023sear__er
seceder10329573s_eceder
secreter1038513secreter
seder64826763s___eder
seeder74320773s__eeder
serener73415763s_erener
shader104218763sha__der
shared105829063shared__
sharer95025483shar__er
sharker144313813shar_ker
sharpener1444583sharpener
sharper124312703shar_per
shredder1334403s_hredder
shrewder1534403s_hrewder
slander84015443sla_nder
slaverer11196993slaverer
smarmier1235033smarmier
smarter94113133smar_ter
snared74824553snared__
snarer64620843snar__er
snarkier12336513snarkier
snarler73610633snar_ler
snarlier8278183snarlier
soared74324293soared__
soarer64522243soar__er
spader94317133spa__der
spared95427493spared__
sparer84524963spar__er
sparger103613083spar_ger
sparker133914363spar_ker
sparkier14298033sparkier
sparkler14317983sparkler
sparrier10329143sparrier
sparser94311483spar_ser
speeder103811073s_peeder
spreader1137483s_preader
staider83912613sta_ider
stampeder14304343stampeder
stander84316163sta_nder
stapedes11197753stapedes
stared75429873stared__
starer64027363star__er
starker114114693star_ker
starrier8279463starrier
starter73817883star_ter
startler8248793startler
starver104611993star_ver
strander97112063strander
strewer104310413s_trewer
strider84315723s_trider
succeeder1442523succeeder
supremer1246483supremer
surrender1074543surrender
swarded1238153swar_ded
swarmer1247803swar_mer
tireder837703_tireder
warder104020273_war_der
yarder103813973_yar_der

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621846.82621412.5
3Display Results1841840.0802300.0
 (SQL Overall)1786911847.32924381.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.