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

113 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
fixtures183528(None) 
fixture1734961fixture_
fixures17596061fix_ures
mixtures1735751mixtures
affixtures2351782affixtures
factures13129022factures
features11310332features
figures11239102fi_gures
filatures1245842filatures
fissures1136572fissures
fixure16256542fix_ure_
futures10310262f_utures
mixture1635412mixture_
pictures1249342pictures
textures1597522textures
admixtures2052193admixtures
affixture2251813affixture_
bistres94017213bist_res
captures1239433captures
ceintures1136733ceintures
cinctures1346043cinctures
cistuses1038283cistuses
clotures10299023clotures
coutures10311973coutures
cultures10310143cultures
dentures9312453dentures
disturbs1145403disturbs
facture12108923facture_
failures1135163failures
feature1039853feature_
featured1237683featured
fetuses10310243f_etuses
fiacres1237253fi_acres
fibres114312123fi__bres
ficuses12159203fi_cuses
fifties132111083fift_ies
figure10258833fi_gure_
figured12196473fi_gured
figurer11215853fi_gurer
figurers12254863fi_gurers
filature1145423filature_
filtered12259043filtered
filterer11258143filterer
filterers12206973filterers
filters103816543filter_s
finitudes1344303finitudes
fiques1837973fi_qu_es
fires85740753fi___res
fissure1036783fissure_
fissured1235183fissured
fistulas1155403fistulas
fitches153516193fi_tches
fitters104517743fitter_s
fixates1737383fix_ates
fixatives2243353fixatives
fixers165112983fix_er_s
fixes154723593fix___es
fixities1838213fixities
flatuses1137173flatuses
flexures1843423flexures
foetuses1136083foetuses
fortunes1158283fortunes
foxfires2142813foxfires
fractures14147233fractures
furfures1445663furfures
future939563f_uture_
gestures9310013gestures
hiatuses1135773hiatuses
ictuses938293_ictuses
immixtures2151883immixtures
immures1136713_immures
injures143111173_injures
insures73117263_insures
inturns73210133_inturns
inures63318953_i_nures
ixtles13217063_ixt_les
jointures16124873jointures
lectures101310153lectures
ligatures1044923ligatures
ligures8269883li_gures
litres65220393li_t_res
matures9314303_matures
mistunes10311133mistunes
mitres83922073mi_t_res
moistures1147313moistures
multures1039333multures
natures7311963_natures
nitres65519333ni_t_res
nurtures837443nurtures
pastures10311963pastures
picture1158613picture_
pictured1346573pictured
postures10313763postures
raptures1037573raptures
remixtures1943233remixtures
rictuses1037563rictuses
ruptures1056683ruptures
situses72710493si_tuses
sixtes133612403sixt__es
sixties14310973sixt_ies
statures83711113statures
sutures7314223_sutures
texture1497083texture_
textured1695483textured
tinctures1144913tinctures
titres64718933ti_t_res
tortures838913tortures
ventures11311483ventures
vestures11311033vestures
viatores11257673viatores
virtues10338023virtu_es
vultures1137213vultures
waftures1434853waftures

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.1561145455.1
2DLD Change Limit1461621137.48319532.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.68523251.9
 
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.