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

157 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
parroting123915(None) 
garroting1136951garroting
arrowing1237942_arrowing
carroming1437682carroming
carrotin102210892carrotin_
carrotins11239962carrotins
farrowing1645872farrowing
garoting10510702ga_roting
garrotting1254202garrotting
harrowing1646442harrowing
marrowing1546662marrowing
narrating10310352narrating
narrowing1345602narrowing
pardoning1338762pardoning
parenting12611582parenting
pargeting1338282pargeting
paroling113316212pa_roling
parring103222062parr__ing
parrying14168132parr_ying
parting103527382pa_r_ting
aborting11710253_aborting
aerating92821003_aerating
airting83616303_air_ting
approving1745053approving
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
garotting1136113garotting
garring93116713garr__ing
harboring1538263harboring
harrying15157643harr_ying
jargoning1845983jargoning
jarring153613193jarr__ing
karting123716063ka_r_ting
karyotin15194833karyotin_
karyotins16234683karyotins
lariating10311793lariating
larruping1243243larruping
marketing1636513marketing
marooning1238593marooning
marring103319553marr__ing
marrying14157233marr_ying
marting103325013ma_r_ting
mirroring1246193mirroring
packeting1836853packeting
painting113614423pa_inting
pairing103716733pair__ing
palleting1238743palleting
palpating1438543palpating
panting104025423pa__nting
parading12313863pa_rading
paragoning1445953paragoning
parawing14310583pa_rawing
parbaking1877203parbaking
parboiling1545173parboiling
parceling1438443parceling
parching164313053pa_rching
parentings1355633parentings
pargetings1443713pargetings
pargetting1444943pargetting
parging113318603pa_r_ging
paring94236493pa_r__ing
parking143423043pa_r_king
parlaying1537303parlaying
parleying1536113parleying
parling103823763pa_r_ling
parodying1655423parodying
parotic112518043pa_roti_c
parotid102915513pa_roti_d
parotids112610413pa_rotids
parqueting2243633parqueting
parrot8320663parrot___
parroted1158853parrot_ed
parroter1058213parrot_er
parroters1156773parroters
parrots9312743parrot__s
parroty1247863parrot__y
parsing103819553pa_r_sing
partaking1698673partaking
partings113513743pa_r_tings
partying14168893pa_rtying
parvolin1376933parvolin_
parvoline1477173parvoline
parvolins1486703parvolins
pasting103826553pa__sting
pastoring12310853pastoring
patenting1248943patenting
patriating13510203patriating
patrolling1345693patrolling
patting103722343pa__tting
permuting1446553permuting
perorating13313133perorating
picoting1338883p_icoting
piloting1139693p_iloting
pirating11314513p_irating
pivoting1436183p_ivoting
pogroming1544733pogroming
porting103021783p_or_ting
prating103424453p__rating
printing113216083p_rinting
probing123314443p__robing
promoting1439923promoting
proofing1439313p_roofing
prorating12314283prorating
prosing103319383p__rosing
proving134214073p__roving
purporting1543793purporting
purposing1445233purposing
purring104515823purr__ing
rioting82716393__rioting
rooting83522433__rooting
serrating10513213serrating
sorrowing1344873sorrowing
sparring113112223sparr__ing
targeting1137303targeting
tarring83318303tarr__ing
tarrying12146723tarr_ying
tarting84222653ta_r_ting
unrooting1098833unrooting
uprooting1276903uprooting
variating13310953variating
varooming1545083varooming
wardrobing1742143wardrobing
warranting1444743warranting
warring113717973warr__ing
worriting1345553worriting

Search took 9 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.406440125.6
2DLD Change Limit1486411577.53019739.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.99922339.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.