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

219 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
telpher123556(None) 
telphers1335471telphers
belcher143511492belcher
helper114313092help_er
teacher123714832teacher
teether10349692teether
telfer9379892tel_fer
teller63519812tel_ler
telphered1544222telphered
temper103914092temp_er
tempter11358212tempter
tether93716102te_ther
welcher15319392welcher
welsher13377442welsher
yelper11458782yelp_er
aether94213673ae_ther
atelier7311623atel_ier
beeper103714093beep_er
belayer12339503belayer
belched154011843belched
belchers153510023belchers
belches143514343belches
belier84423563bel_ier
belter84720963bel_ter
bencher144113483bencher
blether12459913blether
cipher133710263_cipher
cypher16306593_cypher
decipher1644423decipher
deeper93613503deep_er
delayer113010533delayer
deliver113312243deliver
delphic1545103delphic
deluder9168333deluder
delver104913493del_ver
eelier64216463eel_ier
either94517423_either
elater64724203_elater
elder64020023_el_der
elmier839813_elmier
eloper85414153_eloper
eluder73712213_eluder
elver85216243_el_ver
ephor10310013_e_phor
etcher113912943_etcher
ether84518773_e_ther
feather133613503feather
feldsher1543243feldsher
feller94419553fel_ler
fetcher153510393fetcher
filcher15377793filcher
flesher133610923flesher
gelder84613713gel_der
gopher1239183_gopher
gulper93410213gulp_er
gulpier1046953gulpier
heaper114119523heap_er
heather133914853heather
heller93322513hel_ler
helped124714153help_ed
helpers123311853help_ers
hempier14319003hempier
hepper133412663he_pper
keeper123811923keep_er
kelped13449553kelp_ed
kelpie12308613kelpie_
kelpies13289903kelpies
kelter103214383kel_ter
leacher124014843leacher
leaper88118943leap_er
leather103815783leather
lecher113415853le_cher
leper74820743le_p_er
melder93915813mel_der
melter83520113mel_ter
neither1037573neither
nephew1434113ne_phew
nether94014163ne_ther
peacher144216073peacher
peeper103614803peep_er
pelter83321623pel_ter
peopler1138083peopler
pepper93512943pe_pper
peppier10268323peppier
percher143313423percher
pulper103513273pulp_er
pulpier1148623pulpier
ralphed1334363ralphed
reacher123718293reacher
reaper84223143reap_er
relapser1035273relapser
relater73723143relater
relaxer143410223relaxer
relier65826183rel_ier
replier94214973replier
seepier92912013seepier
seller63824593sel_ler
seltzer1635213seltzer
steeper93812773steep_er
stepper113010853ste_pper
sulphur12123873sulphur
sypher14317083_sypher
taler56034863tal__er
talker103916223tal_ker
talkier114011843talkier
taller63721963tal_ler
tallier72817213tallier
tamper104618513tamp_er
taper74829773t_ap_er
tapper104419613t_apper
teachers133212393teachers
teaches122718353teaches
tearer64822903te_arer
tearier73815613tearier
teaser65421523te_aser
teched124014433te_ched
techier1269243techier
tedder83312163te_dder
teemer85515743te_emer
teener64717503te_ener
teenier72611143teenier
teepee8314363teep_ee
teepees939263teepees
teeter65420313te_eter
teethe94511313teethe_
teethed11318623teethed
teethers11328713teethers
teethes103611653teethes
telae54323293tel_ae_
tele45040873tel__e_
telemen9310173telemen
telephoner1554043telephoner
teles54536003tel__es
teleses7313123teleses
telex125214823tel__ex
telexed1536323telexed
telexes1438353telexes
telfers10299073tel_fers
tellers73717593tel_lers
tellies73820503tellies
telnet6518833tel_net
telome8311923telome_
telomere1046433telomere
telomes9310533telomes
telphering1644203telphering
temped113912893temp_ed
tempeh13357463temp_eh
tempehs14325153tempehs
tempera11329043temp_era
temperer12227723temperer
tempers113513013temp_ers
templar1145643templar
temple102811333temple_
templed12278563templed
temples112610893temples
templet112712003templet
tempted12317283tempted
tempters12257293tempters
tenches123515523tenches
tender74121843te_nder
tenner64117103te_nner
tenoner739683tenoner
tenser64919433te_nser
tenter64623933te_nter
tentier73815923tentier
tepee74724213te_p_ee
tepees84215243te_pees
tephra1136483te_phra
termer85717253te_rmer
terrier73414963terrier
terser67317823te_rser
tester64227153te_ster
testier74015643testier
tetched133010773tetched
tetchier1336453tetchier
tethers103815313te_thers
tetter64322453te_tter
thither13328103thither
tiler56131023til__er
tiller64222543til_ler
tilter63417693til_ter
tipper103918413t_ipper
tippier113210543tippier
tippler11348343tippler
tither94920283t_ither
tocher114014913t_ocher
toller63819443tol_ler
toper75231023t_op_er
tophe106718973t_ophe_
tophes115218423t_ophes
topper103817603t_opper
tother94117143t_other
toucher124814353toucher
tougher114210983tougher
trapper113912803trapper
trasher104416133trasher
trencher13279313trencher
tripper113711923tripper
typier1137333t_ypier
veliger1137313veliger
vesper1138083vesp_er
weather133513223weather
weeper114313303weep_er
weepier12319273weepier
weigher14136343weigher
welched16298833welched
welchers16338053welchers
welches153710313welches
welder102914413wel_der
welshed14277203welshed
welshers14246813welshers
welshes13379093welshes
welter93417383wel_ter
wencher153811133wencher
wether123315393we_ther
yeller94214513yel_ler
yelped12439363yelp_ed
yelpers12348203yelp_ers
zephyr2342083ze_phyr

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.403443402.0
2DLD Change Limit1340272196.06322105.7
3Display Results2192190.0802737.5
 (SQL Overall)1786912196.54627297.7
 
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.