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

227 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
arrayer1013670(None) 
arrayed11117151arrayed
arrayers11125851arrayers
abrader1038642abrader
affrayer1742692affrayer
allayer10148212allayer
arranger936872arranger
arrased8149862arrased
arrases71214542arrases
array86317142array__
arrayal1055842arrayal
arrays95311682array_s
arriver10117792arriver
assayer1035572assayer
barrater10310142barrater
brayer115315312_brayer
forayer13368952forayer
grayer106014542_grayer
narrater838722narrater
prayer114815292_prayer
sprayer12369042sprayer
strayer104312502strayer
abaser86414343a_baser
abater85518123a_bater
abrade9313053abrade_
abraded1138643abraded
abraders1137343abraders
abrades10312073abrades
acrider1038623acrider
aerate64830553aerate_
aerated85322373aerated
aerates74627493aerates
aerator7314843aerator
aerier64823153aer_ier
affrayed1842843affrayed
affrayers1842213affrayers
agrafe1038093agrafe_
agrafes1137523agrafes
airer54927893air__er
airier64619363air_ier
allayed11138063allayed
allayers11156633allayers
annoyer1095603annoyer
arame75026623a_rame_
arames84622573a_rames
arbiter939933arbiter
arcade91013643arcade_
arcaded1178973arcaded
arcades101113193arcades
arcane81216743arcane_
archer115016243a_rcher
areae55229743area_e_
arguer74510543a_rguer
arider74717743a_rider
armer76924443a_r_mer
armiger1036253armiger
armorer9259913armorer
arouser74514423arouser
arrack121110253arra_ck
arracks1387733arracks
arraign845063arraign
arraigner1092973arraigner
arrange838683arrange
arranged1036933arranged
arrangers1045813arrangers
arranges939413arranges
arrant6623253arra_nt
arras55626133arra__s
arrayals1154483arrayals
arraying1238753arraying
arrear6310253arr_ear
arrester839253arrester
arrises71617583arrises
arrive91311793arrive_
arrived11127353arrived
arrivers11137003arrivers
arrives101311513arrives
arrowed1148113arrowed
arroyo936963arroy_o
arroyos1036533arroyos
artier63419733a_rtier
artsier768943artsier
assayed1135593assayed
assayers1144843assayers
aurae54128113aura_e_
aurar54420253aura__r
aurate64426473aurate_
aurated83817793aurated
awarder1135893awarder
barracker1744653barracker
barrage10710843barrage_
barraged1297683barraged
barrages11711083barrages
barraters1138043barraters
barrator1048403barrator
barrener1038333barrener
barrier94017733barr_ier
belayer12339503belayer
betrayer1345643betrayer
bewrayer1643733bewrayer
bilayer12347803bilayer
bracer104620583_bracer
braver114719043_braver
brawer114216333_brawer
brayed124615783_brayed
brayers124511903_brayers
brazer174917533_brazer
breaker133912923breaker
broader103412613broader
carmaker1637303carmaker
carrier93619583carr_ier
crater85026643_crater
craver114618463_craver
creamer113714083creamer
creaser94415723creaser
croaker133010683croaker
decayer13339353decayer
defrayer1534933defrayer
delayer113010533delayer
draper94315693_draper
drawer104711363_drawer
drayed115911393_drayed
dreamer104110843dreamer
dryer95111463_dr_yer
eraser64216333_eraser
essayer1033943essayer
farrier103514893farr_ier
flayer124713563_flayer
forager114412563forager
forayed14368593forayed
forayers14277273forayers
forrader1236153forrader
framer114817443_framer
frater94520593_frater
frayed135012163_frayed
fryer115913433_fr_yer
garroter956573garroter
gayer94519193__gayer
grader84919693_grader
grater74625443_grater
graver105018593_graver
grayed115415643_grayed
grazer164815763_grazer
greaser83913083greaser
greater84416493greater
greyer104510093_greyer
groaner82510133groaner
harrier104417753harr_ier
harrower1446363harrower
hayer114620243__hayer
hurrayed1543043hurrayed
inlayer1036933inlayer
irater65218353_irater
krater104014313_krater
larruper1042743larruper
layer84626473__layer
marrer83716673marr__er
marrier93817523marr_ier
narrate7313493narrate_
narrated9310323narrated
narraters946703narraters
narrates8312763narrates
narrator847563narrator
narrower1145063narrower
naysayer1442583naysayer
parader103914863parader
parlayed1435813parlayed
parleyer1335623parleyer
parrier93717653parr_ier
parroter1058203parroter
partaker1436873partaker
partyer12337873partyer
payer105125723__payer
player115215213_player
portrayer1464003portrayer
prater84825353_prater
prayed124815433_prayed
prayers124212853_prayers
preaver121011613preaver
preyer114413733_preyer
pryer104415313_pr_yer
racer75233023__racer
raker94529793__raker
raper74932753__raper
rarer54731703__rarer
raser55633413__raser
rater54943283__rater
ravager1136553ravager
raver85631493__raver
rawer84623733__rawer
rayed95127503__rayed
razer144824273__razer
reader73628293_reader
realer63528593_realer
reamer84325213_reamer
reaper84223143_reaper
rearer64928913_rearer
reaver94524733_reaver
roamer84715163_roamer
roarer63914333_roarer
sayer84926553__sayer
scraper114513413scraper
slayer93916333_slayer
sprayed13398903sprayed
sprayers13367053sprayers
spryer11418533spr_yer
stayer94516483_stayer
strafer103912463strafer
strayed114513283strayed
strayers113510143strayers
stroyer103510783stroyer
swayer125210973_swayer
tarpaper1244603tarpaper
tarrier74323173tarr_ier
taxpayer2041813taxpayer
tracer84820233_tracer
trader75218763_trader
treader84113833treader
treater74219833treater
unarrayed1344183unarrayed
urbaner9177133urbaner
warmaker1735973warmaker
warranter1245193warranter
warrener1136913warrener
waylayer1743153waylayer
wreaker143610043wreaker
wryer11489303_wr_yer

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 Limit1340272277.15618729.3
3Display Results2272270.0762986.8
 (SQL Overall)1786912277.38824186.7
 
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.