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

228 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
searcher1320910(None) 
searched14209251searched
searchers14197351searchers
searches132112901searches
archer115016242__archer
leacher124014842lea_cher
marcher143912972_marcher
peacher144216072pea_cher
percher143313422pe_rcher
reacher123718292rea_cher
researcher1543012researcher
scarcer113911372scarc_er
scorcher15196782scorcher
search113312422search__
searer65432022sear__er
snatcher13167762snatcher
stancher13198812stancher
starched14199312starched
starches131912912starches
starchier1436642starchier
teacher123714832tea_cher
arched125717323__arched
archers124414573__archers
archery15478063__archery
arches114822043__arches
batcher144414853_batcher
beached154516553bea_ched
beaches144120653bea_ches
beachier1538803bea_chier
bearer85323913bear__er
belcher143511493be_lcher
bencher144113483be_ncher
blancher15338633blancher
bleacher15358883blea_cher
breacher153011503brea_cher
catcher143115823_catcher
coacher143714123coa_cher
dearer74822803dear__er
debaucher17123293debaucher
demarche1645533demarche_
demarches1745913demarches
detacher1437543detacher
earache1239323_earache_
earaches13411303_earaches
earlier72612743_earlier
earner63617223_ear_ner
earthed1139923_earthed
earthen1039253_earthen
earthier1137443_earthier
enricher1345003_enricher
etcher113912943_e_tcher
farcer115016083_farc_er
farther1348343_farther
fearer94820183fear__er
feather133613503fea_ther
fetcher153510393fe_tcher
gaucher1337233_gaucher
harsher13310363_harsher
hatcher153314723_hatcher
hearer94323643hear__er
heartier1139093heartier
heather133914853hea_ther
inarched1486113inarched
inarches1358043inarches
larchen12479623_larchen
larches124416443_larches
leached133715043lea_ched
leachers133712813lea_chers
leaches123319343lea_ches
leachier1337253lea_chier
learier73415663lear_ier
learner7319383lear_ner
leather103815783lea_ther
lecher113415853le__cher
lurcher12338133_lurcher
marched153813403_marched
marchen143312073_marchen
marchers153710813_marchers
marches143921173_marches
matcher143214283_matcher
menarche1545813menarche_
menarches1646683menarches
mercer105214203me_rc_er
merches144013763me_rches
nearer64618893near__er
nearlier836793nearlier
parched154013693_parched
parches143720003_parches
patcher143515143_patcher
peached154315883pea_ched
peachers153213843pea_chers
peaches144120053pea_ches
peachier1548623pea_chier
pearler9310373pear_ler
pearlier1037323pearlier
pearter9412743pear_ter
perched154713233pe_rched
perchers153611523pe_rchers
perches143717953pe_rches
poacher143912323poa_cher
preacher153211373prea_cher
rancher123013633_rancher
reached134619083rea_ched
reachers133515723rea_chers
reaches123423203rea_ches
rearer64928913rear__er
researched1643433researched
researchers1652203researchers
researches1544293researches
sachem134012223s_a_chem
sachet114725773s_a_chet
sacker125124843s_a_cker
sarkier113413313s_arkier
satchel123310303s_atchel
saucer84314103s_auc_er
saucier9810283s_aucier
scarce104013633scarc_e_
scareder1135783scareder
scarer84524603scar__er
scarfer124511083scar_fer
scarier94017873scar_ier
scarper114814823scar_per
scarphed1635433scarphed
scarrier10298453scarrier
scorched16187193scorched
scorchers16145513scorchers
scorches15189143scorches
scratcher1635443scratcher
scutcher15176963scutcher
seafarer1144843seafarer
sealer63928963sea__ler
seamer84223613sea__mer
seamier93114633sea_mier
seamster1037143seamster
seance83716683seanc_e_
seances93015343seanc_es
searching1538343searching
searchless1543373searchless
seared75232843sear__ed
seasoner857693seasoner
seater64534153sea__ter
seawater1136603seawater
secreter1038503secreter
seducer1056503seduc_er
seiche11811833se_iche_
seiches12513813se_iches
sepulcher1642633sepulcher
serener73415753se_rener
serer55935503se_r__er
serger73819733se_r_ger
server94917713se_r_ver
seviche1545113seviche_
seviches1635803seviches
sharer95025483shar__er
sharker144313813shar_ker
sharper124312703shar_per
shearer104414683shear__er
sheather1458223shea_ther
sketcher1735433sketcher
slacker133915293sla_cker
slasher104515333sla_sher
slatches131511523slatches
slather103816073sla_ther
sloucher13206813sloucher
smacker153410583sma_cker
smarmier1235033smarmier
smarter94113133smar_ter
smasher123911023sma_sher
smearer94110403smear__er
smearier1036953smear_ier
smirched1634673smirched
smirches1535993smirches
smoocher15205503smoocher
snacker133112603sna_cker
snarer64620843snar__er
snarkier12336513snarkier
snarler73610633snar_ler
snarlier8278183snarlier
snatched14157633snatched
snatchers14146313snatchers
snatches131410713snatches
snatchier1455353snatchier
snitcher13157373snitcher
soarer64522243soar__er
spacer104917793spa_c_er
spacier114011633spa_cier
sparer84524963spar__er
sparger103613073spar_ger
sparker133914353spar_ker
sparkier14298023sparkier
sparkler14317973sparkler
sparrier10329143sparrier
sparser94311483spar_ser
spearer93913663spear__er
stacker134416263sta_cker
stanched14208903stanched
stanchers14206813stanchers
stanches132312793stanches
starch113013203starch__
starchy15286743starch_y
starer64027363star__er
starker114114693star_ker
starrier8279463starrier
starter73817883star_ter
startler8248793startler
starver104611993star_ver
stauncher1443513stauncher
stitcher13168393stitcher
swarmer1247803swar_mer
swarthier1543783swarthier
swasher134011513swa_sher
swatches16169963swatches
swather134213603swa_ther
swearer10349953swear__er
switcher16177683switcher
teachers133212393tea_chers
teaches122718353tea_ches
tearer64822903tear__er
tearier73815613tear_ier
thatcher1635663thatcher
unarched14128553unarched
watcher153113403_watcher
wearer94319403wear__er
wearier103613283wear_ier
weather133513223wea_ther
welcher15319393we_lcher
wencher153811133we_ncher
yearner10336873year_ner

Search took 10 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.1731032896.0
2DLD Change Limit1461622288.71616769.4
3Display Results2282280.0962375.0
 (SQL Overall)1786912288.98519887.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.