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

135 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
apercus113657(None) 
apercu1057381apercu_
acerous9513332acerous
amerces1149852amerces
aperies9423202aperies
apers76629132aper__s
apterous10410462apterous
arcus76918862a__rcus
cercus105013152_cercus
percuss1137162_percuss
perdus93711272_perdus
abacus10349763a_bacus
abortus9397913abortus
acarus8312193acar_us
acetous9410363acetous
aeneus61111143a_eneus
aeries64737783a_eries
agers65027853ager__s
airbus848343a_irbus
alecs76620733ale_c_s
alerts64418223aler_ts
amerce10310513amerc_e
amerced1256523amerced
amercer1146373amercer
amercers1256133amercers
amicus103810003a_micus
amorous9311133amorous
amperes11313983amper_es
anarchs1237093anarchs
anserous8410543anserous
anurous7311553anurous
aper66336233aper___
aperture1046383aperture
apertures1146473apertures
apery106517903aper__y
apes66047433ape___s
apexes1539133ape_xes
apices104916263ap_ices
apodous1037403apodous
aporias9315153aporias
apres75426403ap_r_es
aprons8316993ap_rons
apterium1249133apterium
arcs67834783a__rc_s
arecas84817443are_cas
arenous7314183arenous
argus66716543a__rgus
ascus75013583a__scus
aspects1146743aspe_cts
asperges11318093asperges
aspers86220313asper__s
asperses104111673asperses
aureus65314883a_ureus
aurous64119263a_urous
avers85127313aver__s
averts95715243aver_ts
caperers122611723caperers
capers105428143caper__s
cercis104614493_cercis
cereus85215523_cereus
cerous85821203_cerous
circus104310593_circus
coerces11311943coerces
ecrus75113863__ecrus
ecus65421463__e_cus
eparchs14196243eparchs
gapers94520473gaper__s
japeries17311463japeries
japers154616173japer__s
leprous938843leprous
merces105720743_merces
mercs96020453_merc_s
naperies10313903naperies
onerous7312973onerous
operas8312453oper_as
opercula1244993opercula
opercule1245283opercule
opercules1345573opercules
operons91411743operons
overcut12310423overcut
overcuts1337513overcuts
paperers122410453paperers
papers105125323paper__s
papyrus1444063papyr_us
pareus85420743_pareus
parous84024163_parous
peaces106324083_peaces
pechs125516203_pe_chs
pecks135724433_pe_cks
pecs84634103_pe_c_s
peplus10138343_peplus
perch124518833_perc_h
perches143717953_perches
perdu84216273_perdu_
perdue93912633_perdue
perdues103511333_perdues
peres76246643_per_es
perfuse1247663_perfuse
perils84121853_perils
peris75537073_per_is
peritus9311803_peritus
perks115325803_per_ks
perms95524513_per_ms
perps95521483_per_ps
perses85428063_perses
peruse84016843_per_use
pervs105117373_per_vs
petrous92714423_petrous
pierces113411193pierces
porous84419483_porous
praus74621753_p_raus
precis103416703_precis
precut102016533_precut
precuts111710473_precuts
rapers84327183raper__s
saporous1039053saporous
serous65023563_serous
specks144312703spe_cks
specs96916673spe_c_s
spences113413923spences
spermous1247933spermous
sperms102512603sper_ms
taperers10269773taperers
tapers84025813taper__s
terces83921413_terces
tierces93710453tierces
uppercut1443973uppercut
uppercuts1542573uppercuts
uterus639203uter_us
vaporous1346483vaporous
versus94211143_versus
vertus94613603_vertus
viperous1347613viperous
waterbus1345863waterbus
xerus12313333_xer_us

Search took 8 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 Limit1340271356.98619185.1
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.43524033.8
 
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.