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

187 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
facture1210894(None) 
factures13129041factures
fracture13147141fracture
capture1138912capture
factor11911462factor_
factored1436232factored
factors12912132factors
factory15108352factory
factual1246722factual
failure1035752failure
feature1039852feature
fixture1734962fixture
fractur12135572fractur_
fractured15125062fractured
fracturer14134642fracturer
fractures14147252fractures
fracturs13146322fracturs
future939562f_uture
hachure1545722hachure
lecture9149522lecture
mature8313472ma_ture
nature6311262na_ture
pasture9311462pasture
picture1158612picture
rapture937392rapture
wafture1334852wafture
abjure1536743_abjure
accrue1035823_accrue
accuse103411033_accuse
acquire1835603_acquire
acre67330773_ac__re
active11313743_active
actor71116083_actor_
actors81016773_actors
actual8311023_actual
actuary1245613_actuary
actuate9311443_actuate
acute74720363_ac_ute
acuter84412863_acuter
adjure1435843_adjure
allure63012943_allure
antre55224523_ant_re
arcature1086503arcature
armure8710133_armure
assure6610773_assure
astute6310763_astute
attire62412383_attire
attune637983_attune
azure14911483_a_zure
battue84311003battu_e
cactus104912233cactu_s
cactuses1237933cactuses
captured1336573captured
capturer1246103capturer
captures1239443captures
cincture1245583cincture
cloture9238453cloture
couture9310623couture
culture939393culture
cure66149123__c_ure
dasyure1153823dasyure
datura738043da_tura
denture8311893denture
ductule1065503ductule
facade1238803fac_ade
face96140123fac___e
facer105525053fac_er_
facers115519443fac_ers
facete115014833fac_ete
facetiae1346213facetiae
faceup1334893faceu_p
faciae112913413fac_iae
facile112514883fac_ile
fact97142543fact___
factful1536373factful
faction122613333faction
factoid1338693factoid
factorage1543363factorage
factories14810123factories
factorize2366923factorize
facts107021893fact__s
facula112912233fac_ula
faculae123210353faculae
failures1135163failures
faitour1034883faitour_
faitours1134263faitours
falter94519053falter_
faltered122811003faltered
falterer11239873falterer
falters103916473falters
fanfare1336673fanfare
farceur12525273farceur_
farceurs13464723farceurs
fare76354463fa___re
farther1348343farther
faster94625773faster_
fate75444283fa_t__e
father125116713fa_ther
fatter94523213fatter_
fattier103513463fattier
fauve114712073fa__uve
favour12438333favour_
favoured1533963favoured
favourer1443823favourer
favours13437093favours
featured1237683featured
features11310333features
fiacre1137623fiac__re
fictile1238023fictile
fictive1537023fictive
figure10258833f_igure
filature1145433filature
fissure1036783fissure
fixtures1835283fixtures
fixure16256543f_ixure
flexure1743413flexure
fortune1068303fortune
fractural1444563fractural
fracturers15123213fracturers
fractus12146593fractu_s
fraktur14153043fraktur_
frakturs15163273frakturs
futures10310263f_utures
gesture839243gesture
hachured1744393hachured
hachures1645873hachures
haltere103614713haltere
hectare1238473hectare
juncture1743903juncture
lacquer18135153lacquer
lactary1237853lactary
lactase937963lactase
lactate9312703lactate
lactone9311413lactone
lactose969493lactose
lacune8169673lac_une
lectured11127233lectured
lecturer10136033lecturer
lectures101310163lectures
macabre1335223macabre
macule104115273mac_ule
manure8313653ma_nure
matured10310043ma_tured
maturer938983ma_turer
matures9314313ma_tures
mixture1635413mixture
multure939183multure
nacre75715363nac__re
natured838963na_tured
natures7311963na_tures
noctule936083noctule
nocturn944653nocturn
nocturne1043393nocturne
nurture736643nurture
parure8312523pa_rure
pastured1138233pastured
pasturer1037523pasturer
pastures10311963pastures
pictured1346573pictured
pictures1249343pictures
posture9313253posture
puncture1245053puncture
raptured1155473raptured
raptures1037583raptures
rasure6311423ra_sure
rupture966163rupture
saccule1136743saccule
sacque17107113sacqu_e
saltire73113043saltire
santur6311273santur_
santurs7310763santurs
satire63218003sa_tire
secure8513533sec_ure
stature74410683stature
suture6313203_suture
taciturn1042653taciturn
tactile9310613tactile
tactual936203tactual
tartare73012683tartare
tartufe1064673tartufe
texture1497083texture
tincture1044673tincture
torture738593torture
venture10311173venture
vesture10310373vesture
vulture1036763vulture
waftures1434853waftures

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 Limit1340271875.86022871.5
3Display Results1871870.0802337.5
 (SQL Overall)1786911876.33028229.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.