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

279 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
arrayed1111715(None) 
arrased8149861arrased
arrayer10136701arrayer
abraded1138642abraded
aerated85322372aerated
affrayed1842842affrayed
allayed11138062allayed
arcaded1178972arcaded
arranged1036932arranged
arrases71214542arrases
array86317142array__
arrayal1055842arrayal
arrayers11125852arrayers
arrays95311682array_s
arrived11127352arrived
arrowed1148102arrowed
assayed1135592assayed
aurated83817792aurated
barraged1297682barraged
brayed124615782_brayed
drayed115911392_drayed
forayed14368592forayed
frayed135012162_frayed
grayed115415642_grayed
hurrayed1543042hurrayed
narrated9310322narrated
parlayed1435812parlayed
prayed124815432_prayed
rayed95127502__rayed
sprayed13398902sprayed
strayed114513282strayed
unarrayed1344182unarrayed
aahed917816443a__ahed
abased96514993a_based
abated95918453a_bated
aberrated1245873aberrated
ablated102513443ablated
abrade9313053abrade_
abrader1038643abrader
abrades10312073abrades
acerated113113983acerated
acred87126353acr__ed
aerate64830553aerate_
aerates74627493aerates
aeried74221863aer_ied
afeared1176833afeared
affrayer1742693affrayer
afraid1049723afra_id
aggraded1244203aggraded
agrafe1038093agrafe_
agrafes1137523agrafes
agreed84712503agr_eed
aired66032923air__ed
airshed11258533airshed
airted74214503air_ted
airthed11328303airthed
alarmed1037733alarmed
alated75625143a_lated
alcayde13103723alcayde
allayer10148213allayer
alloyed11158033alloyed
amazed18519313a_mazed
aneared8512743aneared
annoyed1185863annoyed
ansated84214003ansated
aproned10311503aproned
arame75026623a_rame_
arames84622573a_rames
aramid93315613a_ramid
araneid8310803a_raneid
arbored103811603arbored
arcade91013643arcade_
arcades101113193arcades
arcane81216743arcane_
arced88224163a_r_ced
arched125717323a_rched
arcked136211943a_rcked
arcuated1138803arcuated
areae55229743area_e_
argled85314553a_rgled
argued84311173a_rgued
ariled75620323a_riled
armed86324433a_r_med
armored102610473armored
aroused84914343aroused
arrack121110253arra_ck
arracks1387733arracks
arraign845063arraign
arraigned11103033arraigned
arrange838683arrange
arranger936873arranger
arranges939413arranges
arrant6623253arra_nt
arras55626133arra__s
arrayals1154483arrayals
arraying1238753arraying
arrested939153arrested
arrises71617583arrises
arrive91311793arrive_
arriver10117793arriver
arrives101311513arrives
arrogated11147143arrogated
arroyo936963arroy_o
arroyos1036533arroyos
ascared10399523ascared
ashamed1336243ashamed
assayer1035573assayer
aurae54128113aura_e_
aurate64426473aurate_
averaged1356213averaged
aviated11310263aviated
awaked14579203a_waked
awarded1236223awarded
barracked1844753barracked
barrage10710843barrage_
barrages11711083barrages
barrater10310143barrater
barred95725793barr__ed
barreled1137843barreled
bayed115423023__bayed
belayed133610083belayed
beraked144312433beraked
berated104422133berated
betrayed1436303betrayed
bewrayed1733933bewrayed
borated104116363borated
braced115420603_braced
braked135318693_braked
braved124817443_braved
brayer115315313_brayer
brazed184717083_brazed
breaded115014063breaded
breamed124011593breamed
carboyed1637183carboyed
carried103717153carr_ied
carromed1338563carromed
cerated103922473cerated
clayed125013043_clayed
corraded12128293corraded
craaled10339423craaled
craned96121653_craned
craped116120523_craped
crated94827773_crated
craved125417773_craved
crazed184714453_crazed
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323453created
croaked143710533croaked
curated104717583curated
decayed14309333decayed
defrayed1635403defrayed
delayed123310763delayed
derated93623503derated
disarrayed1543293disarrayed
draped105314363_draped
dreaded103612023dreaded
dreamed114310633dreamed
embayed1535443embayed
enraged93511783enraged
erased74816753_erased
errand758793erra_nd
erred65915673err__ed
essayed1134013essayed
estrayed1236393estrayed
farrowed1545283farrowed
fayed126422153__fayed
flayed134414053_flayed
foraged124812283foraged
forayer13368953forayer
framed125116523_framed
freaked15399703freaked
garaged1039253garaged
garred85217403garr__ed
garreted1057523garreted
garroted1056783garroted
graced105217903_graced
graded94919553_graded
grated84523923_grated
graved114818813_graved
grayer106014543_grayer
grazed174115913_grazed
greased93812393greased
greaved12408913greaved
greyed114610603_greyed
groaned9259973groaned
gyrated12428413gyrated
harried113815533harr_ied
harrowed1556263harrowed
hayed125822013__hayed
hoorayed1544013hoorayed
hurrahed1543463hurrahed
jarred144613253jarr__ed
kraaled12254983kraaled
lariated91212063lariated
larruped1142863larruped
layed95127383__layed
lyrated11388473lyrated
marred95421043marr__ed
married104715303marr_ied
marrowed1445973marrowed
mayed115522403__mayed
muraled10410833muraled
narrate7313493narrate_
narrater838723narrater
narrates8312763narrates
narrowed1235203narrowed
okayed1434253_okayed
orated74221503_orated
paraded114014263paraded
parbaked1735503parbaked
parleyed1436233parleyed
parred95024073parr__ed
parried103615723parr_ied
parroted1158843parroted
payed115925933__payed
phrased1387383phrased
pirated102515613pirated
played124815033_played
portrayed1564103portrayed
prated94924923_prated
prayer114815293_prayer
preaged11612333preaged
preyed125313193_preyed
prorated11513713prorated
raced87635313__raced
raged74829453__raged
raked105831423__raked
raped85334623__raped
rared65738323__rared
rased65033933__rased
rated65441383__rated
ravaged1236493ravaged
raved94931433__raved
raxed135622663__raxed
razed155027983__razed
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
redyed114611233_redyed
relayed113212753relayed
roamed95215093_roamed
roared75015393_roared
sashayed1543553sashayed
sayed96127143__sayed
scraped124313133scraped
serrated92513433serrated
slayed104716223_slayed
spayed124213613_spayed
splayed13357813splayed
sprayer12369043sprayer
stayed104817273_stayed
strafed114413333strafed
straked125415343straked
strawed114813613strawed
strayer104312503strayer
stroyed114110863stroyed
swayed133510263_swayed
tarred74720283tarr__ed
tarried83914133tarr_ied
tartrated1096643tartrated
terraced11318123terraced
thrawed1435583thrawed
traced94821583_traced
traded85717683_traded
treaded95014283treaded
treated83618703treated
triaged92810443triaged
troaked12438253troaked
unraked122914013unraked
unrated82621553unrated
unrazed172511453unrazed
uprated103213323uprated
variated121211393variated
warranted1345013warranted
warred104019843warr__ed
wreaked15369023wreaked

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340272797.28018410.3
3Display Results2792790.1102536.4
 (SQL Overall)1786912797.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.