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

368 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
arrased814986(None) 
arrases71214541arrases
arrayed11117151arrayed
abased96514992a_based
abraded1138642abraded
aerated85322372aerated
arcaded1178972arcaded
aroused84914342aroused
arranged1036932arranged
arras55626132arras__
arrayer10136702arrayer
arrested939152arrested
arrises71617582arrises
arrived11127352arrived
arrowed1148102arrowed
aurated83817792aurated
barraged1297682barraged
creased104315582creased
erased74816752_erased
greased93812392greased
narrated9310322narrated
phrased1387382phrased
rased65033932__rased
aahed917816443a__ahed
abase76023483a_base_
abaser86414343a_baser
abases85720773a_bases
abashed1357663a_bashed
abated95918453a_bated
aberrated1245873aberrated
ablated102513443ablated
abrade9313053abrade_
abrader1038643abrader
abrades10312073abrades
abused95614273a_bused
accused12368423accused
acerated113113983acerated
acrasia9310033acrasia
acrasin9311223acrasin
acred87126353acr__ed
advised12136043advised
aerate64830553aerate_
aerates74627483aerates
aeried74221863aer_ied
afeared1176833afeared
affrayed1842843affrayed
afraid1049713afra_id
aggraded1244183aggraded
agrafe1038093agrafe_
agrafes1137523agrafes
agreed84712503agr_eed
aired66032923air__ed
airshed11258533airshed
airted74214503air_ted
airthed11328303airthed
alarmed1037733alarmed
alated75625143a_lated
aliases7914493aliases
allayed11138063allayed
amassed10388623amassed
amazed18519303a_mazed
amused94412513a_mused
aneared8512743aneared
anlases72514903anlases
ansated84214003ansated
appeased1335793appeased
apposed1247853apposed
appraised1445593appraised
apprised1337713apprised
aproned10311503aproned
apyrase1236363apyrase_
apyrases1337243apyrases
arame75026623a_rame_
arames84622573a_rames
aramid93315603a_ramid
araneid8310793a_raneid
arbored103811603arbored
arcade91013643arcade_
arcades101113193arcades
arcane81216743arcane_
arced88224163a_r_ced
archaised1545483archaised
arched125717323a_rched
arcked136211943a_rcked
arcuated1138803arcuated
arcuses94814693arcuses
areae55229743area_e_
areas55935773areas__
argled85314543a_rgled
argued84311173a_rgued
arguses84711743arguses
arias55438023arias__
ariled75620323a_riled
ariose64818723ariose_
arise56436433a_rise_
arisen65316793a_risen
arises65233803a_rises
arkose104911343arkose_
arkoses113910833arkoses
armed86324433a_r_med
armored102610473armored
arose55832083a_rose_
arouse65019983arouse_
arouser74514423arouser
arouses74921293arouses
arrack121110253arra_ck
arracks1387733arracks
arraign845063arraign
arraigned11103033arraigned
arrange838683arrange
arranger936873arranger
arranges939413arranges
arrant6623253arra_nt
array86317143arra__y
arrayal1055843arrayal
arrayers11125853arrayers
arrays95311683arra_ys
arrest63722633arres_t
arrestee849443arrestee
arrester839253arrester
arrests73312683arrests
arris56824683arris__
arrive91311793arrive_
arriver10117793arriver
arrives101311513arrives
arrogated11147143arrogated
arse46539273a_r_se_
arses55733873a_r_ses
ascared10399523ascared
ashamed1336243ashamed
assayed1135593assayed
atlases72410643atlases
aurae54128113aura_e_
auras55932553auras__
aurate64426473aurate_
averaged1356213averaged
avgases11106313avgases
aviated11310263aviated
avulsed1133833avulsed
awaked14579203a_waked
awarded1236223awarded
axised14438963a_xised
barracked1844753barracked
barrage10710843barrage_
barrages11711083barrages
barrater10310143barrater
barred95725793barr__ed
barreled1137843barreled
based85331583__based
beraked144312433beraked
berated104422133berated
biased94012223_biased
borated104116363borated
braced115420603_braced
braised104014803braised
braked135318693_braked
brassed103612373brassed
braved124817443_braved
brayed124615783_brayed
brazed184717083_brazed
breaded115014063breaded
breamed124011593breamed
breasted1138823breasted
browsed134511233browsed
bruised10389503bruised
canvased14246213canvased
carcase11312733carcase_
carcases12313083carcases
caressed1139163caressed
caroused1149253caroused
carried103717153carr_ied
carromed1338563carromed
cased86032413__cased
ceased94920783_ceased
cerated103922473cerated
chased125019293_chased
corraded12128293corraded
craaled10339423craaled
craned96121653_craned
craped116120523_craped
crases85532313_crases
crashed134214203_crashed
crated94827773_crated
craved125417773_craved
crazed184714453_crazed
creaked143413233creaked
creamed123913713creamed
crease85519573crease_
creaser94415723creaser
creases94020963creases
created104323443created
croaked143710533croaked
crossed105313893crossed
cruised103710213cruised
curated104717583curated
cursed94321253cur_sed
debased113310583debased
derated93623503derated
draped105314363_draped
drayed115911393_drayed
dreaded103612023dreaded
dreamed114310633dreamed
dressed93511873dressed
drowsed12448743drowsed
eased65430403__eased
encased103512313encased
enraged93511783enraged
erase54925493_erase_
eraser64216333_eraser
erases64425403_erases
errand758793erra_nd
erred65915673err__ed
farrowed1545283farrowed
feased105718713_feased
foraged124812283foraged
forayed14368593forayed
framed125116523_framed
frayed135012163_frayed
freaked15399703freaked
garaged1039253garaged
garred85217403garr__ed
garreted1057523garreted
garroted1056783garroted
graced105217903_graced
graded94919553_graded
grasped11409063_grasped
grassed93812793grassed
grated84523923_grated
graved114818813_graved
grayed115415643_grayed
grazed174115913_grazed
grease75416233grease_
greaser83913083greaser
greases84816713greases
greaved12408913greaved
groaned9259973groaned
grossed93812253grossed
groused94712833groused
gyrase10508773gyrase_
gyrases11368313gyrases
gyrated12428413gyrated
harassed1237113harassed
harried113815533harr_ied
harrowed1556263harrowed
hearsed113811403hearsed
horsed105321083hor_sed
hurrahed1543463hurrahed
hurrayed1543043hurrayed
incased103612393incased
irised73913153_irised
jarred144613253jarr__ed
kraaled12254983kraaled
lariated91212063lariated
larruped1142863larruped
lased65132343__lased
leased74722883_leased
lyrated11388473lyrated
madrases112610003madrases
marred95421043marr__ed
married104715303marr_ied
marrowed1445973marrowed
muraled10410823muraled
narrate7313493narrate_
narrater838723narrater
narrates8312753narrates
narrowed1235203narrowed
nursed74514663nur_sed
orated74221503_orated
orgasmed1242933orgasmed
orrises71312233orrises
paraded114014263paraded
parbaked1735503parbaked
parlayed1435803parlayed
parred95024073parr__ed
parried103615723parr_ied
parroted1158843parroted
parsed96323893par_sed
perused103112183perused
phased124011973_phased
phrase11109903phrase_
phrases12711463phrases
pirated102515613pirated
pleased103712073pleased
praised104214813praised
prase76128753_prase_
prases84429023_prases
prated94924923_prated
prayed124815433_prayed
preaged11612333preaged
pressed103317313pressed
prised94322203_prised
prissed103311263prissed
prorated11513713prorated
prosed94921093_prosed
pursed95220883pur_sed
raced87635313__raced
raged74829453__raged
raised76120333_raised
raked105831423__raked
raped85334623__raped
rared65738323__rared
rase46149983__rase_
raser55633413__raser
rases55447213__rases
rasped94715203__rasped
rated65441383__rated
ravaged1236493ravaged
raved94931433__raved
raxed135622663__raxed
rayed95127503__rayed
razed155027983__razed
reamed94326123_reamed
reaped94122453_reaped
reared75930013_reared
reaved104523923_reaved
reraised9312353reraised
reused75419563_reused
rinsed75016353_rinsed
roamed95215093_roamed
roared75015393_roared
roasted83912663_roasted
roosed75621593_roosed
rosed65930343__rosed
roused75426443_roused
scraped124313133scraped
serrated92513423serrated
sprayed13398903sprayed
strafed114413323strafed
straked125415343straked
strawed114813613strawed
strayed114513283strayed
surbased1136613surbased
tarred74720283tarr__ed
tarried83914133tarr_ied
tartrated1096633tartrated
teased74721153_teased
terraced11318113terraced
terrases82111453terrases
thrashed1555363thrashed
thrawed1435583thrawed
traced94821583_traced
traded85717683_traded
trashed113514693_trashed
treaded95014283treaded
treated83618703treated
tressed83714253tressed
triaged92810443triaged
troaked12438253troaked
trussed84010013trussed
unarrayed1344183unarrayed
unbased103513483unbased
uncased104216953uncased
unerased9312773unerased
unraised91811883unraised
unraked122914013unraked
unrated82621553unrated
unrazed172511453unrazed
upraised11167413upraised
uprated103213323uprated
urase54624683_urase_
urases63723563_urases
urease64516993urease_
ureases74416723ureases
variated121211393variated
versed104515513ver_sed
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 Limit1340273687.25018486.5
3Display Results3683680.1262920.6
 (SQL Overall)1786913687.53223724.2
 
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.