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

156 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
garotting113610(None) 
garoting10510701garo_ting
garrotting1254191garrotting
gavotting1443191gavotting
garroting1136952garroting
gazetting2043242gazetting
gritting10309982g_ritting
grouting103410792g_routing
rotting82919682__rotting
trotting92510912_trotting
abetting1158293_abetting
aborting11710253_aborting
abutting1137003_abutting
adopting1237453_adopting
allotting1046503allotting
arointing1049363_arointing
arousing93811803_arousing
aroynting1344633_aroynting
batting104422273ba__tting
besotting12256873besotting
blotting113910433_blotting
caroling113317003caro_ling
carolling1259413carolling
caroming133312963caro_ming
carotin92216733caro_tin_
carotins102315583caro_tins
carousing1237893carousing
carpeting1439483carpeting
carting104228283car__ting
cartoning12311113cartoning
catting103922643ca__tting
cavorting1536063cavorting
clotting113110643_clotting
corotating1349323corotating
curetting1236573curetting
darting94020663dar__ting
dartling1039563dar_tling
deratting1139513deratting
dogtrotting1462033dogtrotting
dotting93314483__dotting
dratting10389663_dratting
earthing12310333ear_thing
enrooting10128133enrooting
facetting1535283facetting
fagoting1336283fago_ting
farthing1538073far_thing
farting114120753far__ting
fatting113818703fa__tting
fretting122711523_fretting
fritting123510703_fritting
fronting12310443_fronting
frosting12311183_frosting
frothing15208533_frothing
gadrooning1343543gadrooning
gaiting93716583ga__iting
galleting1137633galleting
galoping1258023galo_ping
gaoling93314653ga_o_ling
garaging1139043gar_aging
garbing113613273gar__bing
garbling12249453gar_bling
gardening1236513gardening
gargling11239203gar_gling
garmenting1445483garmenting
garnering11298083garnering
garotte868703garott__e
garotted1066193garott_ed
garotter965943garott_er
garotters1055033garotters
garottes978283garott_es
garring93116713gar__ring
gartering112111573gartering
gasting95022763ga__sting
gating84826953ga___ting
getting93316563g__etting
ghosting1336463g_hosting
girthing13256083gir_thing
girting93113333gir__ting
gitting93215703g__itting
gloating102611463g_loating
glouting10379693g_louting
glutting10247643g_lutting
gradating1237323gradating
grafting13319623g_rafting
granting103514523g_ranting
grating93923183g_r_ating
greeting103112353g_reeting
grifting13299263g_rifting
groaning102410283g_roaning
groining102310633g_roining
grokking1334813g_rokking
grooming12309513g_rooming
grooving13286713g_rooving
groping113313103g_ro_ping
grossing103111063g_rossing
grottier9316673g_rottier
grouping12308533g_rouping
grousing103410453g_rousing
growing123512473g_ro_wing
growling1348163g_rowling
grunting10269583g_runting
gutting93415923g__utting
gyrating1337453gyr_ating
hatting113920233ha__tting
hotting113116523__hotting
jotting152912773__jotting
karting123716063kar__ting
knotting13236573_knotting
lariating10311793lariating
lotting82917753__lotting
marketing1636513marketing
marooning1238593marooning
marting103325013mar__ting
matting103620143ma__tting
narrating10310353narrating
parenting12611583parenting
pargeting1338283pargeting
pargetting1444943pargetting
parodying1655423parodying
paroling113316213paro_ling
parroting1239153parroting
parting103527383par__ting
partying14168893par_tying
patting103722343pa__tting
plotting113011013_plotting
potting103720893__potting
ragouting1134893ragouting
ratting83822363__ratting
repotting12511123repotting
rerouting10311873rerouting
retting83425883__retting
rooting83522433__rooting
rotating92614553__rotating
routing83821093__routing
rutting82718043__rutting
shotting123012383_shotting
slotting92612613_slotting
spotting112812093_spotting
sprouting1236943sprouting
stotting92811163_stotting
strutting1037003strutting
swotting12268483_swotting
targeting1137303targeting
tarting84222653tar__ting
tatting84019523ta__tting
throating1398403throating
throttling1442793throttling
totting82816843__totting
trothing122410843_trothing
unrooting1098833unrooting
uprooting1276903uprooting
variating13310953variating
varooming1545083varooming
vatting113614853va__tting
warstling1335063warstling
wotting112913843__wotting

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411567.03021143.8
3Display Results1561560.0801950.0
 (SQL Overall)1786911567.54623680.2
 
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.