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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
apoapses124472(None) 
apoapsis1244101apoapsis
apoapsides1542382apoapsides
apodoses1136652apodoses
abases85720773a_ba_ses
admasses1135413admasses
adonises92611433adonises
agapes95212413a_gap_es
agonises92613163agonises
aliases7914493alia_ses
amasses93912853a_masses
anlases72514903anla_ses
apaches143411843ap_aches
apheses12610703ap_heses
aphorises14310003aphorises
apiaries10312733apiaries
apocalypses2051593apocalypses
apocarpies1653533apocarpies
apocopes1445993apocopes
apodosis1146583apodosis
apogamies1445323apogamies
apogees1037103apo_gees
apolunes1045293apolunes
apomixes1934853apomixes
apophases1647973apophases
apophyses1946113apophyses
apoptoses1346443apoptoses
apostles1037753apostles
appeases1238663appeases
applauses1344033applauses
apples104315763ap__ples
apposes11511473ap_poses
appraises1347423appraises
apprises12310963apprises
appulses1234893appulses
apses76823913___apses
apyrases1337243apyrases
arouses74921293aro_uses
arrases71214543arra_ses
asepses946363a_sepses
asynapses1442023asynapses
atlases72410643atla_ses
atomises103514403atomises
atopies92816433ato_pies
avgases11106313avga_ses
avgasses1284193avgasses
azotises1737603azotises
capiases1239253capia_ses
copses104922473_co_pses
corpses113913803_corpses
elapses957663_elapses
epopees1137233epo_pees
eposes84418783epo__ses
gaposises1245523gaposises
lapses85217693__lapses
oases55330983__oa_ses
papooses1248053papo_oses
parses85534703_p_arses
pases75346503_p_a_ses
passes86030473_p_asses
pauses84621473_p_auses
peases85229473_pea_ses
phases114618403_pha_ses
poaches144416943_poaches
poises84226543_po_ises
popes95933813_po_p_es
poppies102816203_poppies
popples103011873_popples
popsies112816463_po_psies
poses74642763_po__ses
posses85128803_po_sses
potpies113116173_potpies
praises94121103_praises
prases84429023_pra_ses
prolapses13145573prolapses
relapses1038033relapses
spouses92912813spo_uses
synapses1344713synapses
upases84112903up_a_ses
upraises10188473upraises
vaporises14209453vaporises
woopses1237883_woopses

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 Filter1786911461620.406440125.6
2DLD Change Limit146162827.11020557.2
3Display Results82820.0302733.3
 (SQL Overall)178691827.54623680.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.