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

265 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
arraying123875(None) 
abrading1239502abrading
aerating92821002aerating
affraying1943102affraying
allaying12339302allaying
arcading1239762arcading
arraign845062arra_ign
arranging1156302arranging
arriving1237362arriving
arrowing1237942arrowing
assaying1236002assaying
barraging1337382barraging
braying134416312_braying
carrying14148372carr_ying
draying123813842_draying
foraying1537432foraying
fraying143413432_fraying
graying124115882_graying
harrying15157642harr_ying
hurraying1654322hurraying
marrying14157222marr_ying
narrating10310352narrating
parlaying1537302parlaying
parrying14168132parr_ying
praying133717322_praying
raying105027192__raying
spraying14299882spraying
straying122912692straying
tarrying12146722tarr_ying
aahing1019015763a__ahing
abasing10610673a_basing
abating10413973a_bating
ablating11311993ablating
abying124410413a__bying
acrasin9311223acrasin_
acrasins1039973acrasins
aerifying1636493aerifying
aggrading1344843aggrading
agreeing10295903agreeing
airing74927503air__ing
airthing12297953airthing
airting83616303air_ting
alarming1138583alarming
aliasing9310073aliasing
alloying12339143alloying
allying113011663a_llying
amazing1938813a_mazing
anearing9413973anearing
annoying1246543annoying
applying1634653applying
aproning11311793aproning
arcadings1354393arcadings
arching136216693a_rching
arcing95819643a_r_cing
arcking145811963a_rcking
argling92812733a_rgling
argufying1742153argufying
arguing9248733a_rguing
arising83619973a_rising
arming94719803a_r_ming
armoring1149123armoring
arousing93811803arousing
arraigning1242783arraigning
arraigns944353arraigns
arrange838683arra__nge
arrant6623253arra__nt
array86317143array___
arrayal1055843array_al
arrayals1154483arrayals
arrayed11117153array_ed
arrayer10136703array_er
arrayers11125853arrayers
arrays95311683array__s
arresting1038633arresting
arrogating121778393arrogating
atrazine1748403atrazine
averaging1446503averaging
aviating12311013aviating
awaking1547813a_waking
awarding1356043awarding
barracking1944713barracking
barreling1238043barreling
barring104021593barr__ing
baying125222583__baying
belaying143110603belaying
beraking153612973beraking
berating113220763berating
berrying14137373berrying
betraying1537713betraying
bewraying1834873bewraying
borating113414503borating
bracing123817613_bracing
braking143917713_braking
braving133714613_braving
brazing193715113_brazing
breading123515463breading
breaking153914253breaking
breaming133612513breaming
burying133413913bur_ying
carroming1437683carroming
claying133614303_claying
corrading1338203corrading
craaling112711353craaling
craning103620303_craning
craping124018713_craping
crating103725203_crating
craving134015733_craving
crazing193914583_crazing
creaking153414123creaking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
croaking153712163croaking
crying123612283_cr_ying
curating11314293curating
currying14196493currying
dairying1336353dair_ying
decaying15239453decaying
defraying1735853defraying
delaying133210973delaying
derating103222283derating
dirtying1336093dirtying
disarraying1644053disarraying
draping114213353_draping
drawing123812053_drawing
dreading113712803dreading
dreaming124011063dreaming
drying113411603_dr_ying
earring83519013earr__ing
embaying1635263embaying
enraging1049573enraging
erasing8317963_erasing
erring73816483err__ing
essaying1235033essaying
estraying1338293estraying
farrowing1645873farrowing
faying134521073__faying
ferrying15146243ferrying
flaying143914463_flaying
foraging1358063foraging
framing133014793_framing
frayings15325993_frayings
freaking163611453freaking
frying134511403_fr_ying
garaging1139043garaging
garring93116713garr__ing
garroting1136953garroting
gracing113216443_gracing
grading103918713_grading
grating93923183_grating
graving123114563_graving
grayling1338003_grayling
grazing183514553_grazing
greasing102811393greasing
greying124110893_greying
groaning102410283groaning
gyrating1337453gyrating
harrowing1646433harrowing
haying134420613__haying
herrying15147023herrying
hooraying1644783hooraying
hurrahing1643753hurrahing
hurrying15145533hurrying
inlaying1247893inlaying
jarring153613193jarr__ing
jurying18337763jur_ying
kraaling13186663kraaling
lariating10311783lariating
larruping1243243larruping
laying104525703__laying
marring103319553marr__ing
marrowing1546663marrowing
maying124421153__maying
narrowing1345603narrowing
naysaying1642983naysaying
okaying1534833_okaying
orating83520323_orating
parading12313863parading
parawing14310583parawing
parbaking1877203parbaking
parleying1536113parleying
parodying1655423parodying
parring103222063parr__ing
parroting1239153parroting
partaking1698673partaking
partying14168893partying
paying123722163__paying
phrasing1438013phrasing
pirating11314513pirating
playing133816093_playing
portraying1645163portraying
prating103424453_prating
prepaying1747973prepaying
preying133114553_preying
prorating12314283prorating
prying124114803_pr_ying
quarrying2273733quarr_ying
racing95030533__racing
raging85126433__raging
raking114728423__raking
rallying12289013rallying
raping94829853__raping
rarefying1654693rarefying
rarifying1646313rarifying
raring74332873__raring
rasing74330833__rasing
rating74938703__rating
ravaging1346323ravaging
raving105128853__raving
raxing144321023__raxing
razing164524543__razing
reading93327213_reading
readying13410223_readying
reaming103924013_reaming
reaping103621213_reaping
rearing83128783_rearing
reaving113820533_reaving
relaying122515153relaying
relying112914613_relying
repaying142712393repaying
resaying122512453resaying
retying113213833_retying
roaming103215793_roaming
roaring82916003_roaring
rubying13297933_rubying
salarying1336073salarying
sashaying1644593sashaying
saying104325543__saying
scraping133310863scraping
scrying1338663scr_ying
serrating10513203serrating
serrying12167693serrying
slaying113316843_slaying
spaying133014623_spaying
splaying14219303splaying
staying114017323_staying
strafing122111193strafing
strawing122411623strawing
stroying122410593stroying
swaying143610643_swaying
tarring83318303tarr__ing
taxpaying2242343taxpaying
terracing1237703terracing
thrawing1535963thrawing
tracing103720153_tracing
trading93517973_trading
treading103515333treading
treating92519613treating
triaging102610543triaging
troaking133310973troaking
trying104214073_tr_ying
unlaying1258363unlaying
unpaying1456943unpaying
unsaying1288153unsaying
uprating11311113uprating
variating13310943variating
varying1429723var_ying
warranting1444743warranting
warrantying1851673warrantying
warring113717973warr__ing
waylaying1953103waylaying
wearying1546703wearying
worrying1534703worrying
wreaking163010213wreaking
wrying13379623_wr_ying

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.1561145455.1
2DLD Change Limit1461622657.42019698.4
3Display Results2652650.1102409.1
 (SQL Overall)1786912657.68623248.9
 
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.