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

112 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
apomixes193485(None) 
apomixis1942921apomixis
admixes1765962a_dmixes
anomies93316992anomi_es
apomicts1444192apomicts
atomies93918362atomi_es
atomises103514402atomises
atomizes192711432atomizes
panmixes1934912panmixes
aconites10314353aconites
admires1038663a_dmires
admixed1833733a_dmixed
adonises92611433adonises
affixes2035503a_ffixes
agonies83016623agoni_es
agonises92613163agonises
agonizes182610583agonizes
alumines10411683alumines
amices105018013a__mices
amides95722663a__mides
amies76837693a__mi_es
amines84727983a__mines
ammines11312673a_mmines
amosites10311233amosites
amphimixes26122873amphimixes
anodizes1837963anodizes
anomie83215963anomi_e_
apatites10311293apatites
aperies9423203aperi_es
apexes1539133ap__exes
aphides134711203ap_hides
aphorises14310003aphorises
aphorizes2348013aphorizes
apices104916263ap__ices
aplites9314933ap_lites
apoapses1244723apoapses
apocopes1445993apocopes
apodoses1136653apodoses
apogamies1445323apogami_es
apogees1037103apo_gees
apolunes1045293apolunes
apomict1349053apomi_ct
aporias9315153apori_as
apostles1037753apostles
applies11311223appli_es
apprises12310963apprises
apprizes2137793apprizes
apsides103911303ap_sides
armies85123693a_rmi_es
armoires1057623armoires
atomics113110853atomi_cs
atomise93013823atomise_
atomised11278833atomised
atomiser10268153atomiser
atomisers11255453atomisers
atomisms12269573atomisms
atomists102610963atomists
atomize183111823atomize_
atomized20279323atomized
atomizer19298533atomizer
atomizers20265553atomizers
atonies75320953atoni_es
atopies92816433atopi_es
avodires1244123avodires
azotises1737603azotises
azotizes1636853azotizes
bemixes18338653_bemixes
bromides13219363bromides
bromines122514253bromines
bromizes21258333bromizes
cacomixles2351563cacomixles
cacomixls2241693cacomixls
camomiles15155633camomiles
caponizes2238703caponizes
commixes2177353commixes
domines102918973_domines
epoxides1844863epoxides
epoxies1637753epoxi_es
fomites123613203_fomites
gaposises1245523gaposises
homies114524723_homi_es
homines123518643_homines
immixes1835073_immixes
mixes147224403___mixes
panmixis1943303panmixis
pixes144323173_p__ixes
podites103014733_podites
pogies94123543_pogi_es
poises84226543_po_ises
pokies125921333_poki_es
polices113118053_polices
polies84034583_poli_es
pomaces132712123_pomaces
pomades123711733_pomades
pomes94833933_pom__es
pommies133712843_pommies
ponies84833463_poni_es
posies84431433_posi_es
poxes145325723_po__xes
premixes193110083premixes
promines123018803promines
promises122916763promises
pumices1338273_pumices
remixes164313873_remixes
roomies93017243roomi_es
saponines1148043saponines
saponites1139943saponites
somites94219123_somites
spadixes1834113spadixes
unmixes16197753_unmixes
vaporises14209453vaporises
vaporizes23228523vaporizes

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621129.12316021.3
3Display Results1121120.0462434.8
 (SQL Overall)1786911129.59218629.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.