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

229 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
abraders113734(None) 
abrader1038641abrader_
abrades10312071abrade_s
abasers95311972ab_asers
abaters95115202ab_aters
abiders104011082ab_iders
abrade9313052abrade__
abraded1138642abrade_d
abridgers1343292abridgers
arrayers11125852arrayers
awarders1245072awarders
beaders104120182_beaders
bladers104214682_bladers
bracers114616702_bracers
braiders114110572_braiders
branders114313092_branders
bravers124715522_bravers
brayers124511902_brayers
brazers184513942_brazers
graders94716012_graders
labradors1243792labradors
paraders113113112paraders
traders84316952_traders
abaser86414343ab_aser_
abases85720773ab_ase_s
abater85518123ab_ater_
abates85825033ab_ate_s
abators94413083ab_ators
abetters1057173abetters
abider95314463ab_ider_
abides94719893ab_ide_s
abjurers1733943abjurers
ablates92416903ablate_s
ablators1069873ablators
abodes94417513ab_ode_s
aborters1038573aborters
abradant1147213abradant
abradants1243893abradants
abrading1239503abrading
abridger1243803abridger_
abridges1245303abridges
abusers94710553ab_users
abutters1056993abutters
acceders1334793acceders
acrider1038623acrider_
adders84315703a__dders
aerates74627493aerate_s
aerators8315613aerators
affrayers1842213affrayers
aggrades1135863aggrade_s
agrafes1137523agrafe_s
aiders74524633a__iders
airers64922313air__ers
alcades101011473alcade_s
alders74218423a__lders
allayers11156633allayers
amenders11288353amenders
anadems1036143a_nadems
arames84622573a_rame_s
arbiters1038853arbiters
arcades101113193arcade_s
archers124414573a_rchers
ardebs937013a_r_debs
ardors74416873a_r_dors
arguers8489033a_rguers
arider74717743a_rider_
armers85520273a_r_mers
arrangers1045813arrangers
arrases71214543arrase_s
arrayer10136703arrayer_
arrivers11137003arrivers
assayers1144843assayers
aubades1038753aubade_s
avoiders1254793avoiders
awardees1243993awardees
awarder1135893awarder_
badgers114812653_b_adgers
bahadurs1442553bahadurs
bakers125323453_b_akers
balers85626933_b_alers
banders104324563_banders
barbers114317503bar_bers
bardes95026933bar_de_s
barkers134318513bar_kers
barraters1138043barraters
barriers104311883barriers
barters94223033bar_ters
bayadeers1541963bayadeers
bayadere1443373bayadere
bayaderes1543583bayaderes
beader94623793_beader_
beakers134216873_beakers
bearers94619593_bearers
beaters94925043_beaters
beavers124417323_beavers
bedders113513383_bedders
benders104021063_benders
bidders114012313_bidders
biders94822803_b_iders
binders103920743_binders
birders103913263_birders
bladders12397803_bladders
blader93618583_blader_
blades95221253_blade_s
blamers115314213_blamers
blazers184811683_blazers
boarders11408623_boarders
boaters93419243_boaters
bonders104120663_bonders
borders104317533_borders
bracer104620583_bracer_
bracero11428743_bracero
braceros12397723_braceros
braces108427773_brace_s
brads85528293_brad__s
braes75735053_bra_e_s
braggers12327903_braggers
braider105112993_braider_
brakes124923123_brake_s
braless92910563_braless
brander103915823_brander_
branners104010923_branners
brasiers103710513_brasiers
braver114719043_braver_
bravery15428133_bravery
braves115524083_brave_s
brawer114216333_brawer_
brawlers13408643_brawlers
brayer115315313_brayer_
brazens18418713_brazens
brazer174917533_brazer_
brazes175522193_braze_s
braziers19397193_braziers
breakers143810973_breakers
bredes94818473_brede_s
breeders11368893_breeders
brewers123811063_brewers
bribers114111503_bribers
brides94423513_bride_s
bridlers11359183_bridlers
briers85319733_br_iers
briners94315633_briners
broadens11267243_broadens
broader103412613_broader_
broiders114211193_broiders
brokers133111913_brokers
brooders112610243_brooders
budders113812103_budders
carders104820353car_ders
corders104520883cor_ders
cradlers11309203_cradlers
craters95021893_craters
cravers124416553_cravers
degraders12245933degraders
deriders102411853deriders
drapers105313353_drapers
drawers113610073_drawers
embracers15105153embracers
erasers74413943_erasers
evaders1136933_evaders
faders105117463__faders
foragers12349633foragers
forayers14277273forayers
framers125113823_framers
fraters103517213_fraters
girders9379943gir_ders
grader84919693_grader_
grades84926313_grade_s
graters85419743_graters
gravers114515273_gravers
grazers175112453_grazers
guarders1035883guarders
hagriders1443553hagriders
hazarders2243023hazarders
headers113819393_headers
herders113914123her_ders
hoarders12307433hoarders
invaders12105303invaders
irades74517393_irade_s
kneaders1384713kneaders
kraters114212343_kraters
labrador1143883labrador_
laders74927763__laders
larders83516943lar_ders
leaders83819603_leaders
loaders83413433_loaders
marauders1244263marauders
miradors1146853miradors
murders103311363mur_ders
narraters946703narraters
obtruders1242493obtruders
orders74315993_or_ders
parader103914863parader_
parades104121463parade_s
paradors113411903paradors
pervaders1544433pervaders
pleaders113210183pleaders
praters94921653_praters
prayers124212853_prayers
racers84725433__racers
radars71314673__radars
raiders84615143__raiders
rakers104123573__rakers
rapers84327183__rapers
rasers64526783__rasers
raters63936583__raters
ravers94628183__ravers
razers154919613__razers
readers83823773_readers
riders74123903__riders
scrapers125510533scrapers
shaders115915553_shaders
spaders104214473_spaders
sprayers13367053sprayers
spreaders1236503spreaders
strafers11379913strafers
stranders10389933stranders
strayers113510143strayers
striders94412123striders
threaders1365743threaders
tirades8311723tirade_s
tracers94917843_tracers
trader75218763_trader_
trades75724503_trade_s
treaders93311843treaders
upbraiders1542363upbraiders
waders109120643__waders
warders113416813war_ders
yarders113211593yar_ders

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.436409841.7
2DLD Change Limit1461622297.89018525.0
3Display Results2292290.0802862.5
 (SQL Overall)1786912298.40621257.6
 
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.