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

126 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
mixture163541(None) 
fixture1734961fixture
mixtures1735751mixtures
admixture1952102admixture
fixtures1835282fixtures
fixure16256542fix_ure
immixture2051902immixture
mature8313472m_ature
mistune9310652mistune
mitre75522422mi_t_re
moisture1046652moisture
multure939182multure
picture1158612picture
remixture1843672remixture
texture1497082texture
admixtures2052193admixtures
affixture2251813affixture
bistre83815023bist_re
capture1138913capture
ceinture1036313ceinture
cincture1245583cincture
cloture9238453cloture
commixture2352393commixture
couture9310623couture
culture939393culture
denture8311893denture
disturb1046233disturb
facture12108933facture
feature1039853feature
figure10258833fi_gure
filature1145433filature
fissure1036783fissure
fixures17596063fix_ures
future939563_future
gesture839243gesture
humiture1344123humi_ture
immature1244443immature
immixtures2151883immixtures
immure1036033_immure
impure1038383_impure
injure133410863_injure
insure63416603_insure
inturn63411563_inturn
inure54119053_i_nure
ixtle12168013_ixt_le
jointure15134833jointure
lecture9149523lecture
ligature945133ligature
ligure7279473li_gure
litre55421463li_t_re
manure8313653m_anure
matured10310043m_atured
maturer938983m_aturer
matures9314313m_atures
measure939033measure
metre74821303m_et_re
micturate1366643micturate
midterm12316013midterm
milter84921233milter_
milters93619093milters
miltier93214963miltier
miniature1145263miniature
mintage101110123mintage
minter84425103minter_
minters93822473minters
mintier93615993mintier
minute83414293mi_nute
minuter93510413minuter
mire66748233mi___re
miscue10412223miscu_e
misfire12229893misfire
misrule939353misrule
mistake131312623mistake
mister84728563mister_
misterm114314513misterm
misters93927513misters
misthrew16124763misthrew
mistier93418713mistier
mistime11312613mistime
mistuned1157723mistuned
mistunes10311133mistunes
mistype14126523mistype
misuse83213643mi_suse
mite66249413mi_t__e
miter75734793mi_ter_
mitered103213233mi_tered
miterer92511333mi_terer
miters84328783mi_ters
mither114218563mi_ther
mitier83620673mi_tier
mitred94414343mi_t_red
mitres83922073mi_t_res
mixable18259173mixable
mixer145017643mix_er_
mixers154513563mix_ers
mixible18195093mixible
mixt136831923mixt___
mixup1636773mix_u_p
mixups1743263mix_ups
moistures1147323moistures
multures1039333multures
mure65941333m___ure
mutule8311423m_utule
nature6311263_nature
nitre57519683ni_t_re
nurture736643nurture
pasture9311463pasture
pictured1346573pictured
pictures1249343pictures
posture9313253posture
rapture937393rapture
remixtures1943233remixtures
rupture966163rupture
sixte126216583sixt__e
stature74410683stature
suture6313203_suture
textured1695483textured
textures1597523textures
tincture1044673tincture
titre54619393ti_t_re
torture738593torture
venture10311173venture
vesture10310373vesture
virtue9358673virtu_e
vulture1036763vulture
wafture1334853wafture

Search took 7 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.390458182.1
2DLD Change Limit1340271266.08022043.9
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.51627423.4
 
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.