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 “apres” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

239 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
apres7542640(None) 
acres76327761acres
apers76629131apers
apes66047431ap_es
apses76823911apses
ares45871021a_res
aures55137091aures
pares77164481pares
abbes96723522abbes
ables75935542ables
abris75722602abris
abyes105518532abyes
aces67645092a_ces
aches106132292aches
acmes96020652acmes
acnes75922622acnes
acre67330772acre_
acred87126352acred
adores74420722adores
adzes155913802adzes
aedes64625142aedes
aeries64737782aeries
afresh1255502afresh
agers65027852agers
ages55844592a_ges
agree65226032agree
agrees74915322agrees
agues64919052agues
aides65336602aides
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airns55521032airns
airs46447422air_s
airts55626342airts
akees96119242akees
ales47067102a_les
almes75126542almes
aloes54933672aloes
amies76837692amies
amperes11313982amperes
anes45255932a_nes
antes56334322antes
antres65021002antres
ape57251182ap_e_
aped78538152ap_ed
apeek114711872apeek
aper66336232ap_er
aperies9423202aperies
apery106517902apery
apex137220212ap_ex
apexes1539132apexes
aphis105917132aphis
apices104916262apices
apnea73413412apnea
apneas83211382apneas
apods86316342apods
apos65433822ap_os
appel94615892appel
appels104312792appels
apples104315762apples
apps86319692ap_ps
apron7318832apron
aprons8316992aprons
apse67725382apse_
apsis75718292apsis
apter76120202apter
aptest82917512aptest
arbs66834732a_rbs
arcs67834782a_rcs
are37874572a_re_
area45843392a_rea
areas55935772a_reas
arfs76029962a_rfs
arks85936872a_rks
arles56735742arles
arms66137492a_rms
arpen74418042arpen
arpens84814822arpens
arras55626132arras
arrest63722632arrest
arris56824682arris
ars37670932a_r_s
arse46539272a_rse
arses55733872arses
arts49650262a_rts
ashes86230612ashes
aspers86220312aspers
aspires9612042aspires
asses55629282asses
ates45047922a_tes
auras55932552auras
aurei54821862aurei
aureus65314882aureus
auris55331532auris
avers85127312avers
aves76142602a_ves
awes76037552a_wes
axes117337852a_xes
axles125219472axles
ayes76543512a_yes
azures15510182azures
bares75457132bares
barres84427542barres
bores76448252bores
byres104421382byres
cadres94017932cadres
capers105428142capers
capes95441922cap_es
capris10415082capris
cares77369182cares
ceres75540012ceres
cires74932912cires
cores76361852cores
cures75645432cures
cypres1338522cypres
dares66146702dares
dures65635922dures
eagres74014572eagres
epees75219832epees
eyres84921772eyres
fares85852872fares
feres86038182feres
fires85740752fires
fores85847102fores
gapers94520472gapers
gapes86030822gap_es
gores65740372gores
gyres94820322gyres
haeres94017032haeres
hares86255542hares
heres86245902heres
hires86134342hires
ires45639282_ires
japers154616172japers
japes146322822jap_es
lapses85217692lapses
lares54852632lares
lores55045402lores
lures56138532lures
lyres85019962lyres
madres93718182madres
maples104819422maples
mares76457632mares
matres84522232matres
meres75143572meres
mires75640882mires
mores76249642mores
mures75937212mures
nacres85614452nacres
napes74828462nap_es
nappes104515622nappes
nares55544152nares
ogres65818632ogres
opes65942612op_es
ores46056682_ores
paces96741112paces
padres95016982padres
pages85235072pages
pales75753802pales
panes76148692panes
papers105125322papers
paras76143042paras
pards85634332pards
pare66760842pare_
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
parers85530742parers
pareu74928742pareu
pareus85420742pareus
parges94529542parges
paries84742512paries
paris75145942paris
parks116134462parks
parles86334402parles
parrs75928672parrs
pars67560792par_s
parse75236992parse
parses85534702parses
parts77743372parts
pases75346502pases
pates76047892pates
paves104833922paves
paxes144928422paxes
pees65257372_pees
peres76246642peres
pes57259782_p_es
pies66949602_pies
pores75849032pores
pree67044732_pree
prees75937172_prees
prep86427672_prep
preps96220692_preps
presa74319042_presa
prese75228382_prese
press75425952_press
prest75736352_prest
prex135722972_prex
prey96228482_prey
preys105717782_preys
prez156126312_prez
pries74339532_pries
pros65742782_pros
pyes95528992_pyes
pyres105523882pyres
rapers84327182rapers
rapes75740722rap_es
raphes115117452raphes
rares55247442rares
res35565042__res
sabres85520862sabres
seres55448892seres
sires55945372sires
sores55454282sores
spaes76029972spaes
spares84834552spares
spies76037622spies
spires84628112spires
spores84726612spores
spree74830862spree
sprees85620642sprees
sprues84515762sprues
spues75025382spues
tapers84025812tapers
tapes75838602tap_es
tares57456562tares
tarres64723042tarres
tires55437492tires
tores55352672tores
tres46542902_tres
tyres84725232tyres
vires84529682vires
wares88250582wares
wires86034912wires
yores85031322yores
zaires1539702zaires

Search took 2 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 Filter178691538000.0762351197.4
2DLD Change Limit538002391.83029398.9
3Display Results2392390.0633793.7
 (SQL Overall)1786912391.96990752.2
 
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.