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

229 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
apposed124785(None) 
appose10411991appose_
apposer1147481apposer
apposes11511471apposes
opposed1236121opposed
appeased1335792appeased
applied1247482applied
apposers1236282apposers
apprised1337712apprised
approved16115072approved
aproned10311502aproned
deposed113412022deposed
exposed1737442exposed
imposed123110292imposed
malposed1344562malposed
oppose1039192oppose_
opposer1135772opposer
opposes1149242opposes
pappose1047412pappose_
posed85828412__posed
prosed94921092_prosed
reposed103616272reposed
supposed1345782supposed
unposed10711902unposed
abased96514993a_based
abioses9311493abioses
aboded104912513a_boded
abused95614273a_bused
accosted1345503accosted
accused12368423accused
adipose1036653adipose_
adiposes1137173adiposes
adopted1136253adopted
adored84714233a_dored
advised12136043advised
alcoved1375613alcoved
aldose7311093aldose_
aldoses8311203aldoses
allowed111610073allowed
alloyed11158033alloyed
amassed10388623amassed
amped104820513amp__ed
amused94412513a_mused
annoyed1185863annoyed
aped78538153a_p__ed
apheses12610703apheses
aphorised1546363aphorised
apnoea867093apno_ea
apod78123183a_po__d
apodoses1136653apodoses
apogee9312553a_pogee
apoptoses1346443apoptoses
apos65433823a_pos__
appalled1344803appalled
apparel1146003apparel
appealed1335593appealed
appeared1336143appeared
appease1137913appease_
appeaser1245953appeaser
appeases1238663appeases
appel94615893app__el
append1138273app_end
appended1435483appended
applaud1293903applaud
apple94517673app_le_
apples104315763app_les
applet105917433app_let
applier1137903applier
applies11311213applies
appoint11612483appoint
appointed1444803appointed
apposing1337403apposing
apposite12410013apposite
appraised1445593appraised
appressed1445943appressed
apprise11310193apprise_
appriser1246783appriser
apprises12310963apprises
apprized2236543apprized
approve14116603approve_
approver15105303approver
approves15126833approves
apps86319693app_s__
appulse1134673appulse_
appulses1234893appulses
apse67725383a_p_se_
apses76823913a_p_ses
arbored103811603arbored
ariose64818723ariose_
arkose104911343arkose_
arkoses113910833arkoses
armored102610473armored
arose55832083a_rose_
aroused84914343aroused
arrased8149863arrased
arrowed1148103arrowed
aspersed11428293aspersed
aspired1068173aspired
aspises9611643aspises
atoned75417543a_toned
autoed7712823auto_ed
avoset9315673a_voset
avowed1335953a_vowed
avulsed1133833avulsed
axised14438963a_xised
azoted16388593a_zoted
baptised1335253baptised
campused1535253campused
capped134721853capp__ed
closed95317963_closed
composed154612063composed
dapped124516763dapp__ed
dappled1336393dapp_led
deponed113712873deponed
depose94215763depose_
deposer104011843deposer
deposes103117213deposes
disposed12310923disposed
dosed76626913__dosed
eposes84418783_eposes
espoused1134853espoused
expose1549523expose_
exposer1637413exposer
exposes1639963exposes
gapped124217123gapp__ed
goosed86817033_goosed
haploses1338853haploses
happed144820103happ__ed
happened1635653happened
hosed95830983__hosed
hypoed1547923hypo_ed
imponed12279453imponed
impose103113043impose_
imposer113310103imposer
imposes113213683imposes
imposted13257403imposted
lapped114320033lapp__ed
lappered13288213lappered
lappeted13255833lappeted
lapsed94712583lap_sed
loosed75520893_loosed
mapped134015883mapp__ed
napped114218163napp__ed
noosed75018013_noosed
nosed65524553__nosed
opposers1244973opposers
osmosed10134843osmosed
papered122513163papered
papoose1147513papoose_
papooses1248053papooses
pappoose1143803pappoose_
pappooses1243983pappooses
paroled104217613paroled
parsed96323893_parsed
passed94320943_passed
paused95114963_paused
peised94817683_peised
phased124011973_phased
phoned124014553_phoned
physed15386793_physed
pissed94816933_pissed
plowed124213203_plowed
ployed124310563_ployed
poised94918473_poised
poked125425393__poked
poled84934843__poled
pooed85226243__pooed
poohed123912523_poohed
pooled94619813_pooled
pooped113915943_pooped
popped104117813_popped
pored85234513__pored
pose66441733__pose_
poser75128773__poser
poses74642763__poses
posted93722493__posted
poxed154817863__poxed
prised94322203_prised
probed114114823_probed
proposed132011073proposed
prose75835123_prose_
proser84223463_proser
proses84733473_proses
proved125016033_proved
ptoses83514673_ptoses
pulsed94013723_pulsed
purposed1335253purposed
pursed95220883_pursed
pyoses114314303_pyoses
rapped114122683rapp__ed
rappeled1335003rappeled
reopposed1444333reopposed
repose84121413repose_
reposer93715333reposer
reposes94021263reposes
riposted11216933riposted
roosed75621593_roosed
rosed65930343__rosed
sapped114422013sapp__ed
sploshed1434323sploshed
spoked134413893_spoked
spoofed13399103spoofed
spooked144510473spooked
spooled104613523spooled
spooned103412443spooned
spoored104411293spoored
spored94821793_spored
spoused10349653spoused
suppose1137973suppose_
supposer1245593supposer
supposes1238203supposes
tamponed1336023tamponed
tapped113820053tapp__ed
trappose1245813trappose_
unopposed1443133unopposed
unpoised1139173unpoised
unposted1159433unposted
upped103715163upp__ed
uppiled12216593uppiled
uprose82311483uprose_
uproused1135833uproused
uptossed1142933uptossed
vamoosed1443923vamoosed
vamosed1335923vamosed
vapored1336923vapored
wapped144416473wapp__ed
woopsed1344733woopsed
yapped144415143yapp__ed
zapped204213523zapp__ed

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.1531167915.0
2DLD Change Limit1340272297.12618808.2
3Display Results2292290.0932462.4
 (SQL Overall)1786912297.37224239.1
 
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.