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

217 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
laborers1020838(None) 
laborer9249501laborer_
labourers1144711labourers
taborers10268331taborers
aborters1038572_aborters
adorers84411732_adorers
borers85122682__borers
clamorers1345782clamorers
favorers1465492favorers
flavorers1563982flavorers
harborers1446912harborers
labelers10249412labelers
labored102810242labore_d
labors84016412labo__rs
labourer1045752labourer_
labours9349892labo_urs
labrets939362lab_rets
layovers1434072layovers
savorers1157222savorers
taborer9269292taborer_
taborets10278062taborets
tabourers1144672tabourers
vaporers1336242vaporers
abasers95311973_abasers
abaters95115203_abaters
abhorrers1442983_abhorrers
abiders104011083_abiders
abjurers1733943_abjurers
abodes94417513_abode_s
aborter939933_aborter_
aborts84916183_abor_ts
abortus9397913_abortus
aboves114512843_above_s
absorbers1353983_absorbers
abusers94710553_abusers
adorer74713453_adorer_
adores74420723_adore_s
adorners9196623_adorners
airers64922313_a_irers
allovers1137673allovers
allurers8286773allurers
almoners1068133almoners
alterers82512493alterers
arbores94016033arbore_s
armorers10288973armorers
atoners75013953_atoners
avowers1336333_avowers
babblers113510353babblers
blabbers11308153blab_bers
blazoners2043863blazoners
boners84825433__boners
borders104317533__borders
boreas85421733__boreas
borer75131273__borer_
bores76448253__bore_s
bowers115523703__bowers
boxers155013483__boxers
cabarets12268463cabarets
cabers105023923cab__ers
cablers114416713cab_lers
cajolers17267133cajolers
caloyers1337343caloyers
canoers94318373cano_ers
caperers122611723caperers
carers85133963ca__rers
carolers103314173carolers
caterers102814403caterers
cavorters1434973cavorters
clabbers14359903clab_bers
clamberers16174113clamberers
clamorer1236903clamorer_
colorers10312183colorers
corers85231073__corers
dabbers123813213dab_bers
dabblers13379363dabblers
dabsters1137053dabsters
darers75921873da__rers
deboners11268113deboners
emborders1444573emborders
embowers15236453embowers
fablers124812613fab_lers
fagoters1234863fagoters
farers95924053fa__rers
favorer1355883favorer_
favourers1543123favourers
flavorer1454553flavorer_
floorers11227573floorers
gabbers124612833gab_bers
gabblers134110083gabblers
galores82614323galore_s
gaolers83511563ga_olers
harborer1348053harborer_
honorers1139263honorers
ignorers9215243ignorers
imbowers15295093imbowers
jabberers2043553jabberers
jabbers183610583jab_bers
jamborees2043273jamborees
jawboners21133053jawboners
laagers83411253la_agers
labarums1254503labarums
labeler92310183labeler_
labellers11206553labellers
labels84515683lab__els
labor75117313labo__r_
laboredly1542383laboredly
laboring112110143laboring
laborious1144763laborious
laborite10410693laborite
laborites1149253laborites
labour84210933labo_ur_
laboured1156323laboure_d
labret8320223lab_re_t
labroids1155843labroids
labrums1175853lab_rums
lacers85225253la__cers
lackers134120543la_ckers
lacquers19125033lacquers
ladders94115173la_dders
laders74927763la__ders
ladlers84613563la_dlers
lagers74826143la__gers
laggers94216243la_ggers
lakers105225153la__kers
lambers113817113la_mbers
lampers113817333la_mpers
lampreys1542883lampreys
lamsters1099753lamsters
lancers93616643la_ncers
lanciers10308543lanciers
landers84026213la_nders
landlers94312833landlers
langrels9106173langrels
lanners73618333la_nners
lappers113717463la_ppers
lapsers93911053la_psers
larders83516943la_rders
larees65323113la__rees
lares54852633la__re_s
larkers113014513la_rkers
lasers64925703la__sers
lashers104121833la_shers
lassoers8338513lassoers
lasters75627693la_sters
latherers12158853latherers
lathers104321883la_thers
lauders84012893la_uders
laughers1235923laughers
launders9358743launders
laurels746663la_urels
laveers10329363la_veers
lavers94526363la__vers
lawyers13377153la_wyers
layers93921183la__yers
layover1334433layover_
lazarets1744803lazarets
libbers113812833lib_bers
libelers10238623libelers
libers84721443lib__ers
lobbers113713943lob_bers
lobbyers1533193lobbyers
lobsters10268743lobsters
loners64225813l__oners
lookers114014073l_ookers
loopers93914033l_oopers
looters74419163l_ooters
lopers84424143l__opers
lores55045403l__ore_s
losers65123583l__osers
lovers94223433l__overs
lowers94624923l__owers
lubbers113913723lub_bers
lumberers13196013lumberers
lurers64217493l__urers
manurers1037593manurers
marrers93414313ma_rrers
maturers1037373maturers
mayoress1344383mayoress
nabbers113710463nab_bers
nabobery1542433nabobery
nabobess1242203nabobess
paperers122410453paperers
parers85530743pa__rers
rabblers123810853rabblers
rebores95319163rebore_s
sabers85224733sab__ers
saboteurs1141863saboteurs
sabres85520863sab_re_s
savorer1057883savorer_
savourers1243833savourers
scorers94115313_scorers
slabbers123610123slab_bers
slalomers1144553slalomers
slaverers12165993slaverers
snorers74313803_snorers
storers75018683_storers
suborders1245503suborders
suborners1146313suborners
tabarets10287233tabarets
tabers84621573tab__ers
tabored102810563tabore_d
taboret92916113tabore_t
taborins103310223taborins
tabors84517113tabo__rs
tabourer1035743tabourer_
tabourets1144163tabourets
tabours94110093tabo_urs
tambourers1442743tambourers
taperers10269773taperers
vaporer1236983vaporer_
vapourers1443373vapourers
wabblers15398993wabblers
wagerers12247613wagerers
wagoners1235473wagoners
waterers112312783waterers
waverers14318613waverers
yabbers14389353yab_bers

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 Limit1461622178.40617387.8
3Display Results2172170.0932333.3
 (SQL Overall)1786912178.65520646.0
 
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.