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

165 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
arrayers1112585(None) 
arrayer10136701arrayer_
abraders1137342abraders
affrayers1842212affrayers
allayers11156632allayers
arrangers1045812arrangers
arrases71214542arrase_s
arrayals1154482arrayals
arrayed11117152arraye_d
arrays95311682array__s
arrivers11137002arrivers
assayers1144842assayers
barraters1138032barraters
brayers124511902_brayers
forayers14277272forayers
narraters946692narraters
prayers124212852_prayers
sprayers13367052sprayers
strayers113510132strayers
abasers95311973a_basers
abaters95115193a_baters
abrader1038643abrader_
abrades10312073abrade_s
aerates74627483aerate_s
aerators8315613aerators
affrayer1742693affrayer_
agrafes1137523agrafe_s
airers64922313air__ers
allayer10148213allayer_
annoyers1185033annoyers
arames84622573a_rame_s
arbiters1038853arbiters
arcades101113193arcade_s
archers124414573a_rchers
arguers8489023a_rguers
armers85520273a_r_mers
armigers1135703armigers
armorers10288963armorers
arousers84810973arousers
arracks1387733arra_cks
arraigners11142683arraigners
arraigns944343arraigns
arranger936873arranger_
arranges939413arranges
arras55626133arra___s
arrased8149863arrase_d
array86317143array___
arrayal1055843array_al
arraying1238743arraying
arrears738843arr_ears
arresters948193arresters
arrises71617583arrise_s
arriver10117793arriver_
arrives101311513arrive_s
arroyos1036533arroy_os
assayer1035573assayer_
awarders1245073awarders
barrackers1843763barrackers
barrages11711083barrage_s
barrater10310143barrater_
barrators1148393barrators
barriers104311883barr_iers
belayers13298143belayers
betrayers1445013betrayers
bewrayers1743483bewrayers
bilayers13296913bilayers
bracers114616703_bracers
bravers124715523_bravers
brayer115315313_brayer_
brazers184513943_brazers
breakers143810973breakers
carmakers1736903carmakers
carriers103614203carr_iers
craters95021883_craters
cravers124416543_cravers
creamers124111293creamers
creasers103612813creasers
croakers14288503croakers
decayers14307963decayers
defrayers1644173defrayers
delayers12268663delayers
drapers105313353_drapers
drawers113610073_drawers
dreamers11369003dreamers
dryers10449273_dr_yers
erasers74413943_erasers
essayers1133563essayers
farriers113610743farr_iers
flayers133912033_flayers
foragers12349623foragers
forayer13368943forayer_
framers125113823_framers
fraters103517203_fraters
fryers125710973_fr_yers
garroters1055813garroters
graders94715993_graders
graters85419733_graters
gravers114515263_gravers
grayer106014543_grayer_
grazers175112443_grazers
greasers93410253greasers
groaners9248493groaners
harriers113712433harr_iers
harrowers1555683harrowers
hayers124415943__hayers
inlayers1135633inlayers
kraters114212333_kraters
larrupers1142523larrupers
layers93921183__layers
marrers93414313marr__ers
marriers103312473marr_iers
narrater838723narrater_
narrates8312753narrate_s
narrators947863narrators
naysayers1542353naysayers
paraders113113113paraders
parleyers1444683parleyers
parriers103612903parr_iers
parroters1156763parroters
partakers1536563partakers
partyers13277763partyers
payers114621823__payers
players124313763_players
portrayers1553603portrayers
praters94921643_praters
prayer114815293_prayer_
preavers13910263preavers
preyers124412363_preyers
pryers115012243_pr_yers
racers84725433__racers
rakers104123573__rakers
rapers84327183__rapers
rasers64526783__rasers
raters63936573__raters
ravagers1235573ravagers
ravers94628183__ravers
razers154919613__razers
readers83823763_readers
reamers94221083_reamers
reapers93520453_reapers
rearers74323563_rearers
reavers108320743_reavers
roamers93713453_roamers
roarers73812733_roarers
sayers94221593__sayers
scrapers125510513scrapers
slayers104513323_slayers
sprayer12369043sprayer_
stayers103813633_stayers
strafers11379903strafers
strayer104312493strayer_
stroyers11388913stroyers
swayers13398853_swayers
tarpapers1344273tarpapers
tarriers83411713tarr_iers
taxpayers2141893taxpayers
tracers94917833_tracers
traders84316943_traders
treaders93311833treaders
treaters83615823treaters
warmakers1845633warmakers
warranters1344523warranters
warreners1236193warreners
waylayers1842943waylayers
wreakers15328423wreakers

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 Limit1461621658.53317129.0
3Display Results1651650.0762171.1
 (SQL Overall)1786911658.76520386.9
 
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.