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

182 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
factures1312904(None) 
facture12108941facture_
fractures14147251fractures
cactuses1237932cactuses
captures1239442captures
factored1436232factored
factories14810122factories
factors12912132factor_s
failures1135162failures
features11310332features
fixtures1835282fixtures
fracture13147142fracture_
fractured15125062fractured
fracturer14134642fracturer
fracturers15123212fracturers
fracturs13146322fractur_s
futures10310262f_utures
hachures1645872hachures
lectures101310162lectures
matures9314312ma_tures
natures7311962na_tures
pastures10311962pastures
pictures1249342pictures
raptures1037582raptures
waftures1434852waftures
abjures1636523_abjures
accrues1135323_accrues
accuses114112193_accuses
acquires1945403_acquires
acres76327763_ac__res
actives12311523_actives
actors81016773_actor_s
actress948533_act_ress
actuaries1147573_actuaries
actuates10310313_actuates
acutes83917723_ac_utes
adjures1536233_adjures
allures72913113_allures
antres65021003_ant_res
arcatures1186853arcatures
armures9510273_armures
assures7611403_assures
attires72312953_attires
attunes737823_attunes
aures55137093_a__ures
azures15510183_a_zures
battues94610193battu_es
cactus104912233cactu__s
capture1138913capture_
captured1336573captured
capturer1246103capturer
capturers1344633capturers
cinctures1346063cinctures
clotures10299023clotures
coutures10311993coutures
cultures10310153cultures
cures75645433__c_ures
dasyures1254153dasyures
daturas838783da_turas
dentures9312453dentures
ductules1155543ductules
facades1339033fac_ades
facers115519443fac_er_s
faces106439433fac___es
facies113921593fac__ies
factions133013063factions
factious13239243factious
factoids1446243factoids
factor11911463factor__
factorages1643513factorages
factorizes2486723factorizes
factory15108353factor_y
facts107021893fact___s
factual1246723factu_al
failure1035753failure_
faitours1134263faitour_s
faltered122811003faltered
falterer11239873falterer
falterers12238043falterers
falters103916473falter_s
fanfares1436773fanfares
farceurs13464723farceur_s
fares85852873fa___res
fastuous1145143fastuous
fates85139233fa_t__es
fathers133916503fa_thers
fatsoes10379423fa_tsoes
fatties103018203fa_tties
fatuous1037783fa_tuous
fauces114916153fa__uces
fauves125610423fa__uves
favoured1533963favoured
favourer1443823favourer
favourers1543123favourers
favours13437093favour_s
favuses1336183fa_vuses
feature1039853feature_
featured1237683featured
fetuses10310243f_etuses
fiacres1237253fiac__res
ficuses12159203fic_uses
figures11239113f_igures
filatures1245863filatures
fissures1136573fissures
fixture1734963fixture_
fixures17596063f_ixures
flatuses1137173flatuses
flexures1843423flexures
focuses12159653foc_uses
foetuses1136083foetuses
fortunes1158283fortunes
fractur12135573fractur__
fractural1444563fractural
fractus12146593fractu__s
frakturs15163273fraktur_s
fucuses12158353fuc_uses
furfures1445663furfures
future939563f_uture_
gestures9310013gestures
hachure1545723hachure_
hachured1744393hachured
halteres113414603halteres
hectares1338863hectares
ictuses938303_ictuses
junctures1844033junctures
lacquers19125033lacquers
lactases1038523lactases
lactates10311233lactates
lactones10311243lactones
lactoses1039833lactoses
lacunes9159623lac_unes
lecture9149523lecture_
lectured11127233lectured
lecturer10136033lecturer
lecturers11124233lecturers
macules114015133mac_ules
manures9313353ma_nures
matres84522233ma_t_res
mature8313473ma_ture_
matured10310043ma_tured
maturer938983ma_turer
maturers1037383ma_turers
maturest1039703ma_turest
mixtures1735753mixtures
multures1039333multures
nacres85614453nac__res
nature6311263na_ture_
natured838963na_tured
noctules1036583noctules
nocturnes1143853nocturnes
nocturns1043733nocturns
nurtures837443nurtures
parures9512693pa_rures
pasture9311463pasture_
pastured1138233pastured
pasturer1037523pasturer
pasturers1136393pasturers
picture1158613picture_
pictured1346573pictured
postures10313783postures
punctures1345343punctures
rapture937393rapture_
raptured1155473raptured
rasures7312013ra_sures
rictuses1037563rictuses
ruptures1056683ruptures
saccules1237033saccules
sacques18106863sacqu_es
saltires83112433saltires
santurs7310763santur_s
satires72617573sa_tires
secures9613163sec_ures
statures83711113statures
sutures7314223_sutures
tartufes1164153tartufes
textures1597523textures
tinctures1144923tinctures
tortures838913tortures
ventures11311493ventures
vestures11311043vestures
vultures1137213vultures
wafture1334853wafture_

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.466383457.1
2DLD Change Limit1461621827.09320606.5
3Display Results1821820.0802275.0
 (SQL Overall)1786911827.63923391.9
 
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.