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

152 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
apercu105738(None) 
apercus1136571apercus
amerce10310512amerce
aper66336232aper__
apers76629132aper_s
apery106517902aper_y
perch124518832_perch
perdu84216272_perdu
acerb9312763acer_b
acerous9513333acerous
aerie54634603a_erie
aero45435343a_er_o
aery77231683a_er_y
agency1237033agency
ager55935843ager__
agers65027853ager_s
alec66430063ale_c_
alecs76620733ale_cs
alert54740653aler_t
alerts64418223alerts
amerced1256523amerced
amercer1146373amercer
amerces1149853amerces
ampere10514413amper_e
amperes11313983amperes
anarch11310393anarch
anergy10156863anergy
apace94718383ap_ace
apart74330673apar_t
ape57251183ape___
apeak115513453ape_ak
aped78538153ape__d
apeek114711873ape_ek
aperies9423203aperies
aperture1046383aperture
apes66047433ape__s
apex137220213ape__x
apexes1539133apexes
apiece10510083apiece
apneic1078623apneic_
aporia8315863aporia
aport75432173apor_t
apres75426403ap_res
apron7318833ap_ron
apter76120203apter__
apteral9311523apteral
apteria9312913apteria
apterium1249133apterium
apterous10410463apterous
apteryx1942383apteryx
arc510250903a__rc_
arch98628443a__rch
arco68331543a__rco
arcs67834783a__rcs
arcus76918863a__rcus
areca75618633are_ca
areic73219393areic_
aspect10612823aspe_ct
asper75520433asper__
aspers86220313asper_s
asperse94210663asperse
aver75931883aver__
avers85127313aver_s
averse95811183averse
avert86029493aver_t
averts95715243averts
caper94831623caper__
capered123014043capered
caperer113013403caperer
capers105428143caper_s
cerci93716393_cerci
cercus105013153_cercus
coerce10310403coerce
ecru65819533__ecru
ecu56828233__e_cu
eparch13258423eparch
fierce11348913fierce
gaper86125123gaper__
gapers94520473gaper_s
haleru94212073haler_u
japer146218883japer__
japers154616173japer_s
japery18439143japer_y
merc87225623_merc_
merch125417963_merch
mercs96020453_mercs
mercy125916183_mercy
napery11489813naper_y
opera7313573oper_a
operas8312453operas
opercula1244993opercula
opercule1245283opercule
operon8811773operon
overcut12310423overcut
paper95128663paper__
papered122513173papered
paperer113111903paperer
papers105125323paper_s
papery134812743paper_y
parch125123003_parch
pareu74928743_pareu
peace95026083_peace
peach125422493_peach
pec76744413_pe_c_
pech116125453_pe_ch
peck125730683_pe_ck
pecs84634103_pe_cs
pence94924453_pence
per56353093_per__
percuss1137163_percuss
perdue93912633_perdue
perdus93711273_perdus
perdy115417333_perdy
pere66450263_per_e
perea75026443_perea
peres76246643_peres
peri65636973_per_i
peril75425953_peril
peris75537073_peris
perk106232843_per_k
perks115325803_perks
perky145319483_perky
perm85834633_per_m
perms95524513_perms
perp89029893_per_p
perps95521483_perps
perry105222713_perry
perse75429523_perse
pert66759323_per_t
perv97224813_per_v
pervs105117373_pervs
pierce104010393pierce
porch125918623_porch
prau66529473_p_rau
precut102016533_precut
raper74932753raper__
rapers84327183raper_s
spec85821973spe_c_
speck135115653spe_ck
specs96916673spe_cs
speech1347563speech
spence103813793spence
sperm93216023sper_m
sperms102512603sperms
taper74829773taper__
tapered102612933tapered
taperer92511793taperer
tapers84025813taper_s
terce75721843_terce
tierce8339843tierce
uppercut1443973uppercut
vertu85017613_vertu

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 Filter1786911127161.000178691.0
2DLD Change Limit1127161527.53314963.0
3Display Results1521520.0463304.3
 (SQL Overall)1786911528.57920828.9
 
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.