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

119 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
turreted93537(None) 
curveted1435292curveted
ferreted1236332ferreted
garreted1057522garreted
targeted1037482targeted
turret63121852turret__
turrets73010672turret_s
accreted1336333accreted
arrested939153_arrested
aurated83817793au_rated
barreled1137843barreled
bucketed1736763bucketed
budgeted1344883budgeted
buffeted1753733buffeted
bulleted1138393bulleted
burdened1236423burdened
burred95820723burr__ed
burrowed1444443burrowed
burseed1049503burse_ed
bursted1039423bu_rsted
burweed1347823burwe_ed
carpeted1338953carpeted
corrected1438113corrected
corseted11311473corseted
curated104717583cu_rated
curetted1137173curetted
curred94319263curr__ed
curried103313653curr_ied
curvetted1543703curvetted
dueted84113593du__eted
excreted1846153excreted
ferreled1234843ferreled
ferreter1136543ferreter
furcated1437593furcated
furred104514433furr__ed
furrowed1563833furrowed
garroted1056783garroted
gorgeted1135353gorgeted
greeted93111383_greeted
gusseted1043553gusseted
hurrahed1543463hurrahed
hurrayed1543043hurrayed
hurried113511043hurr_ied
jerreed1535213jerre_ed
junketed2033523junketed
marketed1537323marketed
murdered1236023murdered
muriated1139793muriated
murrelet10167573murrelet
narrated9310323narrated
outrated92219313outrated
pargeted1238683pargeted
parroted1158843parroted
pureed95017813pu_re_ed
purred94218073purr__ed
purveyed1743363purveyed
quarreled1963433quarreled
quieted17309723qu_ieted
quirted17369213quir_ted
secreted1138633secreted
serrated92513433serrated
surfeited1344593surfeited
surveyed1544233surveyed
tableted1137533tableted
tarred74720283tarr__ed
tarried83914133tarr_ied
tarted74923373t_ar_ted
tartrated1096643tartrated
tarweed1137343tarwe_ed
telneted935073telneted
terete6319333t_erete_
terraced11318123terraced
terreen7257573terre_en
terrene72411033terrene_
terrenes82212603terrenes
terret63425623terret__
terrets72913583terret_s
thirsted1235213thirsted
threated1259203threated
threeped1454373threeped
throated1247923throated
thrusted1265223thrusted
ticketed15146643ticketed
titrated92611683titrated
toileted936993toileted
tormented1245963tormented
torrefied13143053torrefied
touristed1044303touristed
tourneyed1342323tourneyed
treated83618703t_reated
treed65626733t__re_ed
trotted83711283t_rotted
truanted935373truanted
trumpeted1443053trumpeted
trusted83412793t_rusted
trusteed9346533trusteed
trysted11428273t_rysted
tuckered1535963tuckered
tufted10359283tu__fted
tunneled955233tunneled
turbaned1145623turbaned
turbeth1274713turbet_h
turbeths1373353turbeths
tureen63312723tu_re_en
turfed103110963tu_r_fed
turgite837973turgite_
turgites937783turgites
turned73914473tu_r_ned
turpeth1284813turpet_h
turpeths1373153turpeths
turtled8309683tu_rtled
tutted75117443tu__tted
tweeted11336583t_weeted
unrated82621553_unrated
unrented92413923_unrented
unrested91914513_unrested
uprated103213323_uprated
ureter6313203_u_reter
worrited1235743worrited

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 Limit1461621196.53322372.9
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.00225520.0
 
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.