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

207 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
apposer114748(None) 
appose10411991appose_
apposed1247851apposed
apposers1236281apposers
apposes11511471apposes
opposer1135771opposer
appeaser1245952appeaser
applier1137902applier
appriser1246782appriser
approver15105302approver
deposer104011842deposer
exposer1637412exposer
imposer113310102imposer
oppose1039192oppose_
opposed1236122opposed
opposers1244972opposers
opposes1149242opposes
pappose1047412pappose_
poser75128772__poser
proser84223462_proser
reposer93715332reposer
supposer1245592supposer
abaser86414343a_baser
abioses9311493abioses
abuser85413683a_buser
accuser11347933accuser
adipose1036653adipose_
adiposes1137173adiposes
adopter1036753adopter
adorer74713443a_dorer
adviser11135783adviser
airpower1343983airpower
aldose7311093aldose_
aldoses8311203aldoses
allover1038583allover
almoner949383almoner
amasser9418733amasser
ampler104313303amp_ler
amuser84712623a_muser
annoyer1095603annoyer
aper66336233a_p__er
apheses12610703apheses
apnoea867093apno_ea
apodoses1136653apodoses
apogee9312553a_pogee
apoptoses1346443apoptoses
apos65433823a_pos__
apparel1146003apparel
appealer1245743appealer
appear10379343app_ear
appease1137913appease_
appeased1335793appeased
appeasers1345263appeasers
appeases1238663appeases
appel94615893app__el
appetiser1344443appetiser
apple94517673app_le_
apples104315763app_les
applet105917433app_let
applied1247483applied
appliers1235573appliers
applies11311213applies
appoint11612483appoint
appointer1354423appointer
apposing1337403apposing
apposite12410013apposite
appraiser1344953appraiser
apprise11310193apprise_
apprised1337713apprised
apprisers1345053apprisers
apprises12310963apprises
apprizer2145463apprizer
approve14116603approve_
approved16115073approved
approvers16104913approvers
approves15126833approves
apps86319693app_s__
appulse1134673appulse_
appulses1234893appulses
aproned10311503aproned
apse67725383a_p_se_
apses76823913a_p_ses
apter76120203a_p_ter
ariose64818723ariose_
arkose104911343arkose_
arkoses113910833arkoses
armorer9259903armorer
arose55832083a_rose_
arouser74514423arouser
asper75520433asp__er
asperser10408303asperser
aspirer967903aspirer
aspises9611643aspises
atoner64817193a_toner
avoset9315673a_voset
avower1236823a_vower
capper124421983capp__er
capsomer1445773capsomer
chooser124412963chooser
closer84918203_closer
composer145012953composer
dapper114016633dapp__er
dapperer1335763dapperer
depose94215763depose_
deposed113412023deposed
deposers11359243deposers
deposes103117213deposes
disposer11310403disposer
doser66228563__doser
empower14217033empower
eposes84418783_eposes
espouser1044383espouser
expose1549523expose_
exposed1737443exposed
exposers1736133exposers
exposes1639963exposes
gappier12369843gapp_ier
haploses1338853haploses
happier143312033happ_ier
hoser811529763__hoser
impose103113043impose_
imposed123110293imposed
imposers12278453imposers
imposes113213683imposes
imposter12288163imposter
impower14247123impower
lapper104319953lapp__er
lapser84113143lap_ser
looser65219943_looser
loser54728673__loser
malposed1344563malposed
manpower1544703manpower
mapper124516093mapp__er
napper103718283napp__er
nappier114411173napp_ier
nooser65517823_nooser
paper95128663pap__er
paperer113111903paperer
papoose1147513papoose_
papooses1248053papooses
pappier103511593pappier
pappoose1143803pappoose_
pappooses1243983pappooses
parser84822373_parser
passer84721033_passer
pauser84415963_pauser
paviser12489093paviser
pisser84416383_pisser
plover115312613_plover
plower114315063_plower
poiser84217243_poiser
poker115122883__poker
poler74431793__poler
pooler83819843_pooler
poorer82613993_poorer
popover1495843popover
popper93615963_popper
pose66441733__pose_
posed85828413__posed
posers84223973__posers
poses74642763__poses
poseur8419403__poseur
posher115018163__posher
poster84129173__poster
power105325953__power
prober104516073_prober
proper104319953_proper
proposer121810633proposer
prose75835123_prose_
prosed94921093_prosed
prosers94219643_prosers
proses84733473_proses
prosier93817483_prosier
prosper114012183_prosper
prover113819723_prover
prower114218123_prower
ptoses83514673_ptoses
pulser84215193_pulser
purser85020473_purser
pyoses114314303_pyoses
rapper104621573rapp__er
repose84121413repose_
reposed103616273reposed
reposers102911603reposers
reposes94021263reposes
repower12329883repower
rooser63921883_rooser
sapper103822353sapp__er
sappier113613113sapp_ier
sparser94311483sparser
spoofer12368723spoofer
spooler93711383spooler
suppose1137973suppose_
supposed1345783supposed
supposers1344533supposers
supposes1238203supposes
tapper104419613tapp__er
trappose1245813trappose_
unposed10711903unposed
upper93714263upp__er
upriser9218763upriser
uprose82311483uprose_
vaporer1236983vaporer
warpower1645043warpower
yapper133714513yapp__er
zapper193414023zapp__er
zappier20458373zapp_ier

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 Filter1786911340270.343520965.0
2DLD Change Limit1340272078.90615049.1
3Display Results2072070.0802587.5
 (SQL Overall)1786912079.32919154.4
 
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.