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

137 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
garroting113695(None) 
garoting10510701ga_roting
garrotting1254201garrotting
parroting1239151parroting
arrowing1237942_arrowing
carroming1437682carroming
carrotin102210892carrotin_
carrotins11239962carrotins
farrowing1645872farrowing
garotting1136112garotting
garring93116712garr__ing
harrowing1646442harrowing
marrowing1546662marrowing
narrating10310352narrating
narrowing1345602narrowing
aborting11710253_aborting
aerating92821003_aerating
airting83616303_air_ting
aproning11311793_aproning
armoring1149123_armoring
arraying1238753_arraying
arresting1038633_arresting
arriving1237363_arriving
arrogating121778393_arrogating
balloting1238393balloting
barraging1337383barraging
barreling1238043barreling
barring104021593barr__ing
borrowing1544563borrowing
burrowing1544473burrowing
caroling113317003ca_roling
caroming133312963ca_roming
carotin92216733ca_rotin_
carotins102315583ca_rotins
carpeting1439483carpeting
carrotier1146623carrotier
carrying14148373carr_ying
carting104228283ca_r_ting
cartoning12311113cartoning
caryotin13268353caryotin_
caryotins14248043caryotins
cavorting1536063cavorting
charioting1645723charioting
corroding1337943corroding
darting94020663da_r_ting
earring83519013earr__ing
enrooting10128133enrooting
faggoting1543313faggoting
fagoting1336283fa_goting
farting114120753fa_r_ting
ferreting13127703ferreting
furrowing1644063furrowing
gadrooning1343543gadrooning
gaiting93716583ga__iting
galleting1137633galleting
galloping1356253galloping
galoping1258023ga_loping
gamboling1556133gamboling
gammoning1545063gammoning
gaoling93314653ga__oling
garaging1139043ga_raging
garbing113613273ga_r_bing
garbling12249453ga_rbling
gardening1236513gardening
gargling11239203ga_rgling
garmenting1445493garmenting
garnering11298093garnering
garrisoning1352123garrisoning
garron73113493garro__n_
garrons82713463garro__ns
garrote8510113garrot__e
garroted1056793garrot_ed
garroter956593garrot_er
garroters1055823garroters
garrotes969383garrot_es
garrotte965693garrot_te
garrotted1164133garrotted
garrottes1065493garrottes
gartering112111593gartering
gasting95022763ga__sting
gating84826953ga___ting
gavotting1443193gavotting
gazetting2043243gazetting
girting93113333g_ir_ting
gnarring10225973gnarr__ing
gradating1237323gradating
grafting13319623g_rafting
granting103514523g_ranting
grating93923183g__rating
greeting103112353g_reeting
grifting13299263g_rifting
gritting10309983g_ritting
grooming12309513g_rooming
grooving13286713g_rooving
groping113313103g__roping
grouting103410793g_routing
growing123512473g__rowing
grunting10269583g_runting
gyrating1337453g_yrating
harboring1538263harboring
harrying15157643harr_ying
jargoning1845983jargoning
jarring153613193jarr__ing
karting123716063ka_r_ting
karyotin15194833karyotin_
karyotins16234683karyotins
lariating10311793lariating
larruping1243243larruping
marketing1636513marketing
marooning1238593marooning
marring103319553marr__ing
marrying14157233marr_ying
marting103325013ma_r_ting
mirroring1246193mirroring
pardoning1338763pardoning
parenting12611583parenting
pargeting1338283pargeting
paroling113316213pa_roling
parring103222063parr__ing
parrying14168133parr_ying
parting103527383pa_r_ting
rioting82716393__rioting
rooting83522433__rooting
serrating10513213serrating
sorrowing1344873sorrowing
targeting1137303targeting
tarring83318303tarr__ing
tarrying12146723tarr_ying
tarting84222653ta_r_ting
unrooting1098833unrooting
uprooting1276903uprooting
variating13310953variating
varooming1545083varooming
wardrobing1742143wardrobing
warranting1444743warranting
warring113717973warr__ing
worriting1345553worriting

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411376.37623312.6
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.84226116.8
 
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.