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

165 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
garroted105678(None) 
garoted9710131ga_roted
garreted1057521garreted
garrote8510101garrote_
garroter956571garroter
garrotes969361garrotes
garrotted1164131garrotted
parroted1158841parroted
arrowed1148112_arrowed
carromed1338562carromed
farrowed1545282farrowed
garote7717952ga_rote_
garotes8614562ga_rotes
garotted1066192garotted
garred85217412garr__ed
garroters1055812garroters
garrotte965682garrotte
garrottes1065482garrottes
harrowed1556262harrowed
marrowed1445972marrowed
narrated9310322narrated
narrowed1235202narrowed
parroter1058202parroter
aborted10310423_aborted
aerated85322373_aerated
airted74214503_air_ted
aproned10311503_aproned
arbored103811603_arbored
armored102610473_armored
arrased8149863_arrased
arrayed11117153_arrayed
arrested939153_arrested
arrived11127353_arrived
arrogated11147143_arrogated
aurated83817793_aurated
azoted16388593_a_zoted
balloted1189043balloted
barraged1297683barraged
barrater10310143barrater
barred95725793barr__ed
barreled1137843barreled
borrowed1465043borrowed
burrowed1444443burrowed
carboyed1637183carboyed
caroled103717693ca_roled
caromed123713623ca_romed
carotid102014833ca_rotid
carpeted1338953carpeted
carried103717153carr_ied
carrot8423123carrot__
carrotier1146623carrotier
carrotin102210893carrotin
carrots9714623carrot_s
carroty1248943carrot_y
carted98631443ca_r_ted
cartoned111312833cartoned
cavorted1435693cavorted
charioted1595863charioted
corroded12147513corroded
darted84620923da_r_ted
enrooted977423enrooted
faggoted1443103faggoted
fagoted1236073fa_goted
farted105121783fa_r_ted
ferreted1236333ferreted
furrowed1563833furrowed
gadrooned1243403gadrooned
gaited84416923ga__ited
galeated104111583galeated
galleted1038223galleted
galloped12107153galloped
galoped11138083ga_loped
gamboled1435873gamboled
gammoned1444993gammoned
gaoled84814503ga__oled
garaged1039253ga_raged
garbed104815663ga_r_bed
garbled114512803ga_rbled
garboard1247243garboard
gardened1137003gardened
gargled104210673ga_rgled
gargoyled1541993gargoyled
garmented1345883garmented
garnered10247113garnered
garotte868703ga_rotte
garotter965943garotter
garottes978283garottes
garret74426563garr__et
garrets84413623garret_s
garrisoned1242283garrisoned
garron73113493garro__n
garrons82713463garro_ns
garroting1136953garroting
garter74420513ga_r_ter
gartered10319593gartered
gasted84821583ga__sted
gated75329773ga___ted
gavotted1363343gavotted
gazetted19234853gazetted
girted83912873g_ir_ted
gnarred9327013gnarr__ed
gorgeted1135353gorgeted
gradated1157433gradated
grafted124110223g_rafted
granted94715103g_ranted
grated84523923g__rated
greeted93111383g_reeted
grifted12379583g_rifted
gritted94110903g_ritted
groomed11379503g_roomed
grooved12347253g_rooved
groped107515053g__roped
grouted94111503g_routed
groved114413703g__roved
grunted9339283g_runted
gyrated12428413g_yrated
harbored1438633harbored
harried113815533harr_ied
harrower1446363harrower
jargoned1735233jargoned
jarred144613253jarr__ed
lariated91212063lariated
larruped1142863larruped
marketed1537323marketed
marooned1138563marooned
marred95421043marr__ed
married104715303marr_ied
marted94425213ma_r_ted
mirrored1145773mirrored
narrate7313493narrate_
narrater838723narrater
narrates8312763narrates
narrower1145063narrower
pardoned12189333pardoned
parented11912213parented
pargeted1238683pargeted
paroled104217633pa_roled
parotid102915513pa_rotid
parred95024073parr__ed
parried103615723parr_ied
parroket1449203parroket
parrot8320663parrot__
parroters1156763parroters
parrots9312743parrot_s
parroty1247863parrot_y
parted94228683pa_r_ted
rioted73416373__rioted
rooted75424003__rooted
serrated92513433serrated
sorrowed1264833sorrowed
targeted1037483targeted
tarred74720283tarr__ed
tarried83914133tarr_ied
tarted74923373ta_r_ted
tartrated1096643tartrated
turreted935373turreted
unrooted9810513unrooted
uprooted1186393uprooted
variated121211393variated
varoomed1445293varoomed
wardrobed1662523wardrobed
warranted1345013warranted
warred104019843warr__ed
warted104223233wa_r_ted
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.420425454.8
2DLD Change Limit1461621657.01620832.7
3Display Results1651650.0762171.1
 (SQL Overall)1786911657.51223787.4
 
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.