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

227 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
earaches1341130(None) 
earache1239321earache_
apaches143411832_apaches
arches114822042_ar_ches
braches144621222_braches
caroaches1637792caroaches
caroches15710692caroches
enriches1337262enriches
ganaches1437412ganaches
headaches1845032headaches
heartaches1844042heartaches
huaraches1744992huaraches
larches124416442lar_ches
marches143921172mar_ches
oraches124216472_oraches
panaches15310282panaches
parches143720002par_ches
searches132112902sear_ches
abashes12510373_abashes
aches106132293___aches
aerates74627483aera_tes
aitches123014363_aitches
apache134210773_apache_
arables91814973_arables
arames84622573_ara_mes
arcades101113193_arcades
arched125717323_ar_ched
archer115016243_ar_cher
archers124414573_ar_chers
attaches13137723attaches
babiches1735253babiches
baches135426943__baches
backaches22146813backaches
barathea1345273barathea
baratheas1444913baratheas
barnacles1355333barnacles
barouches1644973barouches
batches144019613ba_tches
beaches144120653_beaches
berdaches1745053berdaches
birches143412323bir_ches
bleaches153410673bleaches
boraces113716853borac_es
borsches1536003borsches
braces108427773_brac_es
brachet144020313_brachet
brachets154311983_brachets
brachs134415753_brach_s
branches153613803branches
brashes124518463_brashes
breaches153714113breaches
broaches153211623broaches
caches137926913__caches
calashes13310533calashes
caleches15269933caleches
caliches153812263caliches
capuches1735503capuches
caracals12310743caracals
caracks152211563carac_ks
caracoles13310073caracoles
caracols12310413caracols
caraculs1238033caraculs
carafes125015703cara_fes
carates95630603cara_tes
carcases12313083carcases
carices114220953caric_es
caroche1469243caroche_
carroches1665893carroches
carwashes1745773carwashes
catches144320763ca_tches
coaches144018693_coaches
coracles121811163coracles
cranches153114543cranches
crashes124618403_crashes
cratches153012543cratches
creches14313093_creches
curacies12311763curacies
curches143512743cur_ches
demarches1745913demar_ches
detaches1439653detaches
drachms1534253_drachms
earlobes1056143earlobes
earthed1139923ear_thed
earthen1039253ear_then
earths95014593ear_th_s
earwaxes1844703earwaxes
eatables10169793eatables
eches106322163e___ches
effaces15277273effac_es
embraces14128863embrac_es
emdashes14224303emdashes
encashes13227673encashes
encroaches1743083encroaches
endashes12217453endashes
enfaces122110913enfac_es
enlaces92313393enlac_es
enrages83114853enra_ges
enriched1435863enriched
enricher1345003enricher
enrichers1444133enrichers
eparchies1646973epar_chies
eparchs14196243epar_ch_s
erases64425403e_ra_ses
errancies1147963errancies
etches114217763e__tches
exarchies2145213exar_chies
exarchs19165193exar_ch_s
farces115223323far_c_es
farcies125317883far_cies
gamashes1456943gamashes
ganache1346203ganache_
garages9314113gara_ges
gearcases1254693gearcases
gouaches1436193gouaches
graces94523493_grac_es
halachas16317883halachas
harasses11311033harasses
hatches153420273ha_tches
haunches1656963haunches
headache1744703headache_
headachey2142553headachey
headraces1546613headrac_es
heartache1743703heartache_
huarache1644313huarache_
huarachos1743283huarachos
hyraces1537913hyrac_es
inarches1358043inar_ches
karaokes1145013karaokes
karates115617473kara_tes
kirsches1743843kirsches
laches116528343__laches
larchen12479623lar_chen
latches123320123la_tches
launches1387903launches
lavashes1445573lavashes
leaches123319343_leaches
loaches123613983_loaches
lurches123311663lur_ches
maches134827233__maches
manacles1239523manacles
manches143818623ma_nches
maracas11313773marac_as
marched153813403mar_ched
marchen143312073mar_chen
marcher143912973mar_cher
marchers153710813mar_chers
marchesa15346883mar_chesa
marchese15358913mar_chese
marchesi15337323mar_chesi
mariachis1644703mariachis
marishes13512553marishes
marshes123615373mar_shes
matches143219783ma_tches
menarches1646683menar_ches
merches144013763mer_ches
miracles1238333miracles
naches114622413__naches
nautches1336073nautches
orache114013593_orache_
oracles93212423_oracles
painches1588913painches
palaces114216453palac_es
panache1458423panache_
panoches1548123panoches
papacies1439473papacies
parables121613563parables
parachor1546653parachor
parachors1647403parachors
parachutes1744153parachutes
parades104121463para_des
paraphs1439313paraph_s
parched154013693par_ched
parchesi15358213par_chesi
parishes13314753parishes
patches143320383pa_tches
paunches1568173paunches
peaches144120053_peaches
pearlashes1543253pearlashes
perches143717953per_ches
piracies12312643piracies
pleaches153210433pleaches
poaches144416943_poaches
porches143815673por_ches
preaches153214893preaches
races74943243__rac_es
rachet115028973__rachet
rachets124516833__rachets
rachis114017653__rachis
ranches123620113ra_nches
raphes115117453__raphes
rashes95330153__rashes
ratches123620463ra_tches
raunches1368053raunches
reaches123423203_reaches
reattaches1543563reattaches
rebranches1745193rebranches
reproaches1755433reproaches
reteaches1437123reteaches
retraces101417263retrac_es
riches115022083__riches
roaches123616213_roaches
ruches114819583__ruches
sarapes94617743sara_pes
scratches1647313scratches
seabeaches1742753seabeaches
searched14209253sear_ched
searcher13209103sear_cher
searchers14197353sear_chers
soroches1338803soroches
starches131912913star_ches
taches114224173__taches
takahes1436173taka_hes
teaches122718353_teaches
terraces102712223terrac_es
thrashes1487653thrashes
torches123715433tor_ches
traces85329933_trac_es
trachea12311673_trachea
tracheas13410273_tracheas
trachles13311753_trachles
tranches132915513tranches
trashes104119253_trashes
troches123715343_troches
upreaches1654633upreaches
varices123313573varic_es
watches153017373wa_tches
wearables14155003wearables

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.1531167915.0
2DLD Change Limit1461622278.44017317.8
3Display Results2272270.0932440.9
 (SQL Overall)1786912278.68620572.3
 
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.