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

169 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
telphers133547(None) 
telpher1235561telpher_
belchers153510022belchers
helpers123311852help_ers
teachers133212392teachers
teethers11328712teethers
telfers10299082tel_fers
tellers73717612tel_lers
telphered1544222telphered
tempers113513012temp_ers
tempters12257292tempters
tethers103815312te_thers
welchers16338052welchers
welshers14246812welshers
yelpers12348202yelp_ers
aethers103614943ae_thers
ateliers837903atel_iers
beepers113612383beep_ers
belayers13298143belayers
belcher143511493belcher_
belches143514343belche_s
beliers94617383bel_iers
belters93819413bel_ters
benchers153611013benchers
blethers13429613blethers
ciphers14379993_ciphers
cyphers17316753_cyphers
deciphers1744393deciphers
delayers12268663delayers
delivers123310753delivers
deluders10156433deluders
delvers113411993del_vers
elaters74420193_elaters
elders74817303_el_ders
elopers95112943_elopers
eluders8409913_eluders
elvers93814983_el_vers
ephors11311403_e_phors
etchers123411293_etchers
ethers94518413_e_thers
feathers143513243feathers
feldshers1643093feldshers
fellers104117543fel_lers
fetchers16328863fetchers
filchers16286863filchers
fleshers14339443fleshers
gelders93812573gel_ders
gophers1338983_gophers
gulpers10299013gulp_ers
heapers123616673heap_ers
heathers143914733heathers
hellers103619833hel_lers
helper114313093help_er_
helpless1335063helpless
jeepers16399193jeep_ers
keepers133410983keep_ers
kelpies13289903kelpie_s
kelters113813753kel_ters
leachers133712813leachers
leapers93716663leap_ers
leathers114215083leathers
lechers123313963le_chers
lepers84817323le_p_ers
melders103213913mel_ders
melters93918313mel_ters
nephews1533323ne_phews
peachers153213843peachers
peepers113713673peep_ers
pelters93720313pel_ters
peoplers1237163peoplers
peppers103311443pe_ppers
perchers153611523perchers
pulpers114612283pulp_ers
reachers133515723reachers
reapers93520453reap_ers
relapsers1164123relapsers
relaters83218153relaters
relaxers15298263relaxers
reliers75519213rel_iers
repliers103710163repliers
sellers73721323sel_lers
seltzers1735063seltzers
steepers103011373steep_ers
steppers12289283ste_ppers
sulphurs1383653sulphurs
syphers15317273_syphers
talers64628153tal__ers
talkers113513213tal_kers
talliers83711383talliers
tampers113516743tamp_ers
tapers84025813t_ap_ers
tappers113416543t_appers
teacher123714833teacher_
teaches122718353teache_s
tearers75218233te_arers
teasers75317243te_asers
tedders94010233te_dders
teemers95012903te_emers
teeners74415453te_eners
teepees939263teep_ees
teeters74018303te_eters
teether10349693teether_
teethes103611653teethe_s
telephoners1653323telephoners
teles54536003tel__e_s
teleses7313123telese_s
telexes1438353telexe_s
telfer9379903tel_fer_
teller63519833tel_ler_
tellies73820513tellie_s
telnets738373tel_nets
telomere1046433telomere
telomeres1146363telomeres
telomes9310533telome_s
telphering1644203telphering
tempehs14325153temp_ehs
temper103914093temp_er_
tempera11329043temp_era
temperas12278233temp_eras
temperers13247023temperers
templars1255263templars
temples112610893temple_s
templets12226143templets
tempter11358213tempter_
tenches123515523tenche_s
tenders83719723te_nders
tenners74014923te_nners
tenoners858713tenoners
tenters73921113te_nters
tepees84215243te_p_ees
tephra1136483te_ph_ra
tephras1236283te_phras
termers95414503te_rmers
terriers84210823terriers
testers74124543te_sters
tether93716103te_ther_
tetters74320473te_tters
tilers63523503til__ers
tillers73418743til_lers
tilters73315953til_ters
tippers113414353t_ippers
tipplers12336353tipplers
tithers104216733t_ithers
tochers123413093t_ochers
tollers73217463tol_lers
topers85025323t_op_ers
tophes115218423t_ophe_s
toppers113914603t_oppers
touchers133611213touchers
trappers123711043trappers
trashers113013643trashers
trenchers14288073trenchers
trippers123210163trippers
veligers1237023veligers
vespers1239033vesp_ers
weathers143412833weathers
weepers123511973weep_ers
weighers15135673weighers
welcher15319393welcher_
welches153710313welche_s
welders113313413wel_ders
welsher13377443welsher_
welshes13379093welshe_s
welters103516063wel_ters
wenchers16319213wenchers
wethers135214693we_thers
yellers103912953yel_lers
yelper11458783yelp_er_
zephyrs2441943ze_phyrs

Search took 9 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.453394461.4
2DLD Change Limit1461621697.64019131.2
3Display Results1691690.0802112.5
 (SQL Overall)1786911698.17321863.6
 
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.