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

247 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
forayers1427727(None) 
foragers12349631foragers
forayer13368951forayer_
affrayers1842212affrayers
arrayers11125852arrayers
brayers124511902_brayers
flayers133912032f_layers
foamers123812102fo_amers
forager114412562forager_
forages114217282forage_s
foramens1337822foramens
forayed14368592foraye_d
forays124813002foray__s
forcers124215712for_cers
forevers1438172forevers
forgers115218182for_gers
forgoers1236412forgoers
forkers144615782for_kers
formers128217952for_mers
forsakers1644652forsakers
foyers125413132fo__yers
framers125113822f_ramers
fraters103517212f_raters
fryers125710972f_r_yers
prayers124212852_prayers
sprayers13367052sprayers
strayers113510142strayers
abraders1137343abraders
affrayer1742693affrayer_
allayers11156633allayers
arrayer10136703arrayer_
assayers1144843assayers
belayers13298143belayers
betrayers1445013betrayers
bewrayers1743483bewrayers
bilayers13296923bilayers
boarders11408623boarders
boaters93419243bo_aters
boraces113716853borace_s
borages103917163borage_s
boranes93720403borane_s
borates94823013borate_s
boraxes163511633boraxe_s
borders104317533bor_ders
borers85122683bor__ers
bowyers15438733bo_wyers
bracers114616703_bracers
bravers124715523_bravers
brayer115315313_brayer_
brazers184513943_brazers
coalers94419353co_alers
coaters93525793co_aters
coaxers164311083co_axers
comakers16339173comakers
corders104520883cor_ders
corers85231073cor__ers
corkers134118853cor_kers
corners94723313cor_ners
coroners104016223coroners
corulers1039773corulers
craters95021893_craters
cravers124416553_cravers
croakers14288523croakers
decayers14307963decayers
defrayers1644173defrayers
delayers12268663delayers
dormers104313923dor_mers
dorpers104113173dor_pers
dorsers83516303dor_sers
dowagers1334893dowagers
drapers105313353_drapers
drawers113610073_drawers
dryers10449273_dr_yers
erasers74413943_erasers
essayers1133563essayers
facers115519443f__acers
faders105117463f__aders
fakers134219533f__akers
farcers124713443far_cers
farers95924053f__arers
farmers124315263far_mers
farriers113610743farriers
fearers104815273f_earers
firers94922683fir__ers
firmers124711443fir_mers
flakers143613273f_lakers
flamers124616363f_lamers
flayer124713563f_layer_
floaters112711513floaters
flyers125712803f__lyers
foamer114714313fo_amer_
focusers13134373focusers
fodders124010753fo_dders
foggers124112013fo_ggers
folates103218453folate_s
folders113514393fo_lders
fondlers12338023fondlers
footers104618333fo_oters
footlers113910793footlers
foozlers20346073foozlers
forage104617003forage__
foraged124812283forage_d
foramen12310533forame_n
forams115115913fora__ms
foray115023973foray___
foraying1537433foraying
forbearers1543673forbearers
forbears1337073forbears
forbye14427883forbye__
forceps14466983for_ceps
forcer114917343for_cer_
forces114422133for_ce_s
fordless12289003fordless
fordoes11311963fordoe_s
forebears1446413forebears
foregoers1345953foregoers
forelegs1236613forelegs
fores85847103for__e_s
foreseers1237403foreseers
foresees11311643foresees
foresters12312533foresters
forever1338953forever_
foreyard1546423foreyard
foreyards1645503foreyards
forgathers1743553forgathers
forger104820773for_ger_
forgery14419303for_gery
forges105024263for_ge_s
forgets113813793for_gets
forgivers1643713forgivers
forgoer1137693forgoer_
forgoes11311353forgoe_s
forker134717903for_ker_
forkier144311593forkier_
forkless15267433forkless
formates132814293formate_s
formatters1544573formatters
former114221403for_mer_
formes114623713for_me_s
formless13248083formless
formyls15235703formy_ls
forrader1236153forrader_
forsaker1545103forsaker_
forsakes1536893forsake_s
forswears1543243forswears
fortes95327183for_te_s
forties104323863fortie_s
fortress1136753fortress
forwarders1743443forwarders
fosters104220103fo_sters
founders123911673founders
fowlers133411203fo_wlers
foyer116416553fo__yer_
framer114817443f_ramer_
frames115119863f_rame_s
frankers15348353f_rankers
frater94520593f_rater_
frayed135012163f_raye_d
frays116920103f_ray__s
freers94717303f_r_eers
friers94718933f_r_iers
frizers19329553f_rizers
frothers14279813frothers
frowners14377933frowners
fryer115913433f_r_yer_
furanes103214863furane_s
furlers104214223fur_lers
furriers11369493furriers
furthers1436493furthers
gorgers94813643gor_gers
graders94716013_graders
graters85419743_graters
gravers114515273_gravers
grayer106014543_grayer_
grazers175112453_grazers
groaners9248503groaners
hayers124415943__hayers
hoarders12307433hoarders
hoaxers17327133ho_axers
homagers1486823homagers
inlayers1135643inlayers
kraters114212343_kraters
layers93921183__layers
loaders83413433lo_aders
loafers10349463lo_afers
loaners73913623lo_aners
lobbyers1533193lobbyers
locaters102710073locaters
lorimers1036613lorimers
loriners839963loriners
moaners92813553mo_aners
moneyers1337423moneyers
morales93619403morale_s
morays114613883moray__s
northers1139333northers
oaters65029793_o_aters
obeyers1234813_obeyers
onagers838103_onagers
orates64328613_orate_s
orators7313823_orators
orders74315993_or_ders
ormers84316143_or_mers
oyers87620883_o__yers
paraders113113113paraders
partyers13277763partyers
payers114621823__payers
players124313763_players
porkers134314933por_kers
porters93722703por_ters
portrayers1553603portrayers
praters94921653_praters
prayer114815293_prayer_
preyers124412363_preyers
pryers115012243_pr_yers
racers84725433__racers
rakers104123573__rakers
rapers84327183__rapers
rasers64526783__rasers
raters63936583__raters
ravers94628183__ravers
razers154919613__razers
roamers93713463ro_amers
roarers73812743ro_arers
sayers94221593__sayers
scrapers125510533scrapers
slayers104513323_slayers
soakers114114953so_akers
soapers93715923so_apers
soarers74118093so_arers
socagers1196363socagers
solacers10268893solacers
sorners73416873sor_ners
sorters74221133sor_ters
sprayer12369043sprayer_
stayers103813633_stayers
strafers11379913strafers
strayer104312503strayer_
stroyers11388923stroyers
swayers13398853_swayers
torquers17204303torquers
toyers95516333to__yers
tracers94917843_tracers
traders84316953_traders
voyagers1532813voyagers
workers144612693wor_kers
wormers124012573wor_mers
worriers11257813worriers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622477.47019566.5
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.96922423.3
 
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.