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

107 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
torturer83549(None) 
torture738591torture_
tortured935841tortured
torturers944341torturers
tortures838911tortures
nurturer844472nurturer
posturer1038922posturer
torquer16205322torqu_er
totterer8217792totterer
tourer64115072to__urer
barterer102711643barterer
borderer1168103borderer
bordure1035783bordure_
bordures1136173bordures
capturer1246093capturer
colourer1037563colourer
conjurer17117683conjurer
coruler9311713cor_uler
costumer1275103costumer
couture9310623couture_
coutures10311993coutures
couturier1145423couturier
dourer74215273do__urer
fortune1068303fortune_
fortuned1285323fortuned
fortunes1158283fortunes
fosterer11239523fosterer
gesturer935983gesturer
honourer1146243honourer
lecturer10136033lecturer
loiterer837083loiterer
maturer938983_maturer
mortared1137213mortared
mortiser1078483mortiser
murmurer1242873murmurer
norther1039733nort_her
nurture736643nurture_
nurtured935253nurtured
nurturers943353nurturers
nurtures837443nurtures
obtuser9134453_obtuser
orderer8127943_orderer
ordure756813_ordure_
ordures856473_ordures
pasturer1037523pasturer
perjurer17285903perjurer
perturber1343153perturber
porter84224413port__er
portered112311543portered
portlier1038373portlier
posture9313253posture_
postured1139493postured
posturers1137053posturers
postures10313783postures
potterer102310263potterer
pourer84516043po__urer
procurer1235833procurer
roturier836033ro_turier
sorcerer1036433sorcerer
sorter64425093sort__er
sourer63620213so__urer
tabourer1035743tabourer
tartare73012683tartare_
tarter64023563tart__er
tartier74123263tart_ier
tartufe1064673tartufe_
tartufes1164153tartufes
texture1497083texture_
textured1695483textured
textures1597523textures
titterer8268523titterer
tonsure758783tonsure_
tonsured976383tonsured
tonsures869133tonsures
tooter64420803toot__er
toothier1136423toothier
tootler73511123toot_ler
torchier1337463torchier
torque15237673torqu_e_
torqued17224893torqu_ed
torquers17204303torquers
torques16217513torqu_es
torrider936173torrider
torte55431703tort__e_
torten65314353tort__en
tortes64826053tort__es
tortile7313193tortile_
tortrix1444193tort_rix
tortuous845903tortuous
torturing1036253torturing
torturous944453torturous
toter55932133to_t__er
tother94117143to_t_her
totter65021463to_t_ter
tottered9208703tottered
totterers9186813totterers
toured74216153to__ured
tourers73512743to__urers
touter63821033to__uter
trotter73312253trot_ter
trouper93811433t_rouper
trouser73812473t_rouser
troutier8277153troutier
truer54916643t_r_u_er
turtler72610323turt_ler
venturer1137243venturer
worthier1436713worthier

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.423422437.4
2DLD Change Limit1461621076.95321021.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911077.42224075.9
 
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.