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
arraying123874(None) 
abrading1239502abrading
aerating92820992aerating
affraying1943102affraying
allaying12339302allaying
arcading1239762arcading
arraign845062arra_ign
arranging1156302arranging
arriving1237362arriving
arrowing1237942arrowing
assaying1236002assaying
barraging1337372barraging
braying134416312_braying
carrying14148362carr_ying
draying123813842_draying
foraying1537432foraying
fraying143413432_fraying
graying124115882_graying
harrying15157632harr_ying
hurraying1654312hurraying
marrying14157212marr_ying
narrating10310342narrating
parlaying1537302parlaying
parrying14168122parr_ying
praying133717322_praying
raying105027192__raying
spraying14299882spraying
straying122912692straying
tarrying12146712tarr_ying
aahing1019015763a__ahing
abasing10610673a_basing
abating10413973a_bating
ablating11311993ablating
abying124410413a__bying
acrasin9311223acrasin_
acrasins1039973acrasins
aerifying1636493aerifying
aggrading1344833aggrading
agreeing10295903agreeing
airing74927503air__ing
airthing12297953airthing
airting83616303air_ting
alarming1138583alarming
aliasing9310073aliasing
alloying12339143alloying
allying113011663a_llying
amazing1938813a_mazing
anearing9413973anearing
annoying1246543annoying
applying1634653applying
aproning11311793aproning
arcadings1354383arcadings
arching136216693a_rching
arcing95819643a_r_cing
arcking145811963a_rcking
argling92812733a_rgling
argufying1742153argufying
arguing9248733a_rguing
arising83619973a_rising
arming94719803a_r_ming
armoring1149123armoring
arousing93811803arousing
arraigning1242783arraigning
arraigns944343arraigns
arrange838683arra__nge
arrant6623253arra__nt
array86317143array___
arrayal1055843array_al
arrayals1154483arrayals
arrayed11117153array_ed
arrayer10136703array_er
arrayers11125853arrayers
arrays95311683array__s
arresting1038633arresting
arrogating121778383arrogating
atrazine1748403atrazine
averaging1446503averaging
aviating12311013aviating
awaking1547813a_waking
awarding1356043awarding
barracking1944703barracking
barreling1238043barreling
barring104021593barr__ing
baying125222583__baying
belaying143110603belaying
beraking153612963beraking
berating113220753berating
berrying14137363berrying
betraying1537703betraying
bewraying1834863bewraying
borating113414503borating
bracing123817613_bracing
braking143917703_braking
braving133714613_braving
brazing193715113_brazing
breading123515463breading
breaking153914243breaking
breaming133612513breaming
burying133413913bur_ying
carroming1437673carroming
claying133614303_claying
corrading1338193corrading
craaling112711353craaling
craning103620303_craning
craping124018713_craping
crating103725203_crating
craving134015733_craving
crazing193914583_crazing
creaking153414113creaking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
croaking153712153croaking
crying123612283_cr_ying
curating11314293curating
currying14196483currying
dairying1336353dair_ying
decaying15239453decaying
defraying1735843defraying
delaying133210973delaying
derating103222273derating
dirtying1336093dirtying
disarraying1644053disarraying
draping114213353_draping
drawing123812053_drawing
dreading113712803dreading
dreaming124011063dreaming
drying113411603_dr_ying
earring83519013earr__ing
embaying1635263embaying
enraging1049563enraging
erasing8317953_erasing
erring73816473err__ing
essaying1235033essaying
estraying1338293estraying
farrowing1645873farrowing
faying134521073__faying
ferrying15146233ferrying
flaying143914463_flaying
foraging1358063foraging
framing133014793_framing
frayings15325983_frayings
freaking163611443freaking
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
herrying15147013herrying
hooraying1644783hooraying
hurrahing1643743hurrahing
hurrying15145523hurrying
inlaying1247893inlaying
jarring153613193jarr__ing
jurying18337763jur_ying
kraaling13186663kraaling
lariating10311783lariating
larruping1243243larruping
laying104525703__laying
marring103319543marr__ing
marrowing1546653marrowing
maying124421153__maying
narrowing1345603narrowing
naysaying1642983naysaying
okaying1534833_okaying
orating83520323_orating
parading12313863parading
parawing14310583parawing
parbaking1877193parbaking
parleying1536103parleying
parodying1655423parodying
parring103222063parr__ing
parroting1239153parroting
partaking1698663partaking
partying14168893partying
paying123722163__paying
phrasing1438013phrasing
pirating11314513pirating
playing133816093_playing
portraying1645163portraying
prating103424453_prating
prepaying1747973prepaying
preying133114553_preying
prorating12314283prorating
prying124114803_pr_ying
quarrying2273733quarr_ying
racing95030533__racing
raging85126433__raging
raking114728413__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
serrating10513193serrating
serrying12167683serrying
slaying113316843_slaying
spaying133014623_spaying
splaying14219303splaying
staying114017323_staying
strafing122111193strafing
strawing122411623strawing
stroying122410593stroying
swaying143610643_swaying
tarring83318303tarr__ing
taxpaying2242343taxpaying
terracing1237683terracing
thrawing1535963thrawing
tracing103720153_tracing
trading93517973_trading
treading103515333treading
treating92519613treating
triaging102610543triaging
troaking133310963troaking
trying104214073_tr_ying
unlaying1258363unlaying
unpaying1456943unpaying
unsaying1288153unsaying
uprating11311113uprating
variating13310933variating
varying1429723var_ying
warranting1444743warranting
warrantying1851673warrantying
warring113717973warr__ing
waylaying1953103waylaying
wearying1546693wearying
worrying1534693worrying
wreaking163010203wreaking
wrying13379623_wr_ying

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622658.34317519.1
3Display Results2652650.1102409.1
 (SQL Overall)1786912658.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.