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

184 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
torture73859(None) 
tortured935841tortured
torturer835491torturer
tortures838911tortures
bordure1035772bordure
couture9310612couture
fortune1068302fortune
nurture736642nurture
ordure756802_ordure
posture9313252posture
tartare73012682tartare
tartufe1064672tartufe
texture1497082texture
tonsure758782tonsure
torque15237672torqu_e
torquer16205322torquer
torte55431702tort__e
tortile7313192tortile
torturers944342torturers
aortae65115473aort_ae
aperture1046383aperture
armure8710133_armure
bordures1136163bordures
capture1138903capture
cloture9238453cloture
coenure968143coenure
colure8314153co_lure
conjure16109063conjure
contuse9311413contuse
cornute939633cornute
cortege1098943cortege
costume1157853costume
coutures10311973coutures
coverture1445403coverture
culture939393culture
denture8311893denture
facture12108923facture
feature1039853feature
fioriture1243043fioriture
fixture1734963fixture
forbare122310513forbare
forbore12249673forbore
forte86131463fort__e
fortuned1285323fortuned
fortunes1158283fortunes
future939563_future
gesture839243gesture
goitre7349003goit_re
jointure15134833jointure
lecture9149513lecture
mature8313463_mature
mixture1635413mixture
moisture1046653moisture
morgue938113morgu_e
mortar83812043mortar_
mortared1137213mortared
mortars93411523mortars
mortary12369043mortary
mortice11711493mortice
mortise9713533mortise
mortuary1373923mortuary
multure939183multure
nature6311263_nature
nervure1034973nervure
noctule936083noctule
nocturn944653nocturn
nocturne1043393nocturne
norther1039733norther
nurtured935253nurtured
nurturer844473nurturer
nurtures837443nurtures
obtuse8147483_obtuse
ordures856463_ordures
outre53922193_out_re
overture111511683overture
parure8312523par_ure
pasture9311463pasture
perdure10379623perdure
perjure16327963perjure
perturb1146003perturb
picture1158613picture
portage103013643portage
porter84224413porter_
portered112311533portered
porters93722703porters
portiere1038773portiere
postured1139493postured
posturer1038923posturer
postures10313763postures
procure1138573procure
purpure1195993purpure
rapture937383rapture
rondure837293rondure
rupture966163rupture
soilure736233soilure
sorter64425083sorter_
sorters74221113sorters
sortie63621983sort_ie
stature74410673stature
stoure64814943sto__ure
suture6313203_suture
tarre55825633tar__re
tartar63214753tartar_
tartars73313403tartars
tarter64023563tarter_
tartier74123263tartier
tartufes1164153tartufes
tartuffe1461903tartuffe
tenure6311613t_enure
textured1695483textured
textures1597523textures
tincture1044673tincture
titre54619393t_it_re
togue64816303to_gu_e
tongue7410093tongu_e
tonsured976383tonsured
tonsures869133tonsures
tontine72316143tontine
tooter64420803tooter_
tooters73818773tooters
tootle62613813toot_le
tootler73511123tootler
tootsie737123tootsie
toque145113093to_qu_e
torchere1347673torchere
tore47359323to___re
torero6313203tor_ero
torose64317693tor_ose
torous64319023torou_s
torpor839193torpor_
torpors939373torpors
torquate1745003torquate
torqued17224893torqued
torquers17204303torquers
torques16217513torques
torr45630903tor__r_
torrs53923563tor__rs
torsade837593torsade
torse55833333tor__se
tort46967463tort___
torta55925353tort__a
tortas64918253tort_as
torten65314353tort_en
tortes64826053tort_es
tortoise847093tortoise
tortoni738033tortoni
tortrix1444183tortrix
torts56138123tort__s
tortuous845893tortuous
torturing1036253torturing
torturous944443torturous
torula6610393tor_ula
torulae758553torulae
torus54329763tor_u_s
tote46643673to_t__e
toter55932133to_ter_
toters65026363to_ters
tother94117143to_ther
totter65021463totter_
tottered9208703tottered
totterer8217793totterer
totters74618733totters
tottery10388483tottery
tour45530373to__ur_
toured74216153to__ured
tourer64115073to__urer
tours55325863to__urs
touse55430673to__use
touter63821033touter_
touters74018333touters
triune64210183t_riune
trotter73312253trotter
troupe84812433t_roupe
truce75118693t_r_uce
true46725853t_r_u_e
truer54916643t_r_uer
turtle63213573turt_le
turtler72610323turtler
venture10311173venture
verdure11287773verdure
vesture10310373vesture
virtue9358673virtu_e
vulture1036763vulture
wafture1334853wafture

Search took 9 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.1561145455.1
2DLD Change Limit1340271848.20316338.8
3Display Results1841840.0632920.6
 (SQL Overall)1786911848.42221217.2
 
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.