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

282 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
laborer924950(None) 
labored102810241labored
laborers10208381laborers
labourer1045751labourer
taborer9269291taborer
aborter939922_aborter
adorer74713442_adorer
borer75131272__borer
clamorer1236902clamorer
favorer1355882favorer
flavorer1454552flavorer
harborer1348052harborer
labeler92310182labeler
labor75117312labo__r
labors84016402labor_s
labour84210932labo_ur
laboured1156322laboured
labourers1144712labourers
labret8320222lab_ret
layover1334432layover
savorer1057882savorer
tabored102810562tabored
taborers10268332taborers
taboret92916112taboret
tabourer1035742tabourer
vaporer1236982vaporer
abaser86414343_abaser
abater85518123_abater
abhorrer1343383_abhorrer
abider95314463_abider
abjurer1634743_abjurer
abler75624313_ab_ler
abode85518813_abode_
aboded104912513_aboded
abodes94417513_abodes
aboral8314373_aboral
abort76133583_abor_t
aborted10310423_aborted
aborters1038563_aborters
aborts84916183_aborts
above105414323_above_
aboves114512843_aboves
absorber1254303_absorber
abuser85413683_abuser
adore65723663_adore_
adored84714233_adored
adorers84411723_adorers
adores74420713_adores
adorner8246973_adorner
afore85818603_afore_
airer54927893_a_irer
allover1038583allover
allurer7348433allurer
almoner949383almoner
alterer72713993alterer
arbored103811603arbored
arbores94016033arbores
armorer9259903armorer
atoner64817193_atoner
avower1236823_avower
babbler104012823babbler
babier103515563bab_ier
barer74535803__barer
belabored1443813belabored
blabber10418923blab_ber
blazoner1944133blazoner
boner75133083__boner
border94419973__border
bore66051333__bore_
bored85034303__bored
borers85122683__borers
bores76448253__bores
bower107328183__bower
boxer145016523__boxer
cabaret112519043cabaret
caber95126833cab__er
cabler104519173cab_ler
cajoler16398393cajoler
caloyer1238143caloyer
canoer85121073cano_er
caperer113013403caperer
carer74942333ca__rer
caroler93816753caroler
caterer92815933caterer
cavorter1335783cavorter
clabber134210113clab_ber
clamberer15185263clamberer
clamored1336943clamored
clamorers1345783clamorers
colorer9312523colorer
corer75538873__corer
dabber114816963dab_ber
dabbler124012153dabbler
dabster1036703dabster
darer65230793da__rer
deboner103110483deboner
eagerer8248823eagerer
emborder1345083emborder
embower14267403embower
fabber134814113fab_ber
fabler116115813fab_ler
fagoter1135883fagoter
fairer95212063fa_irer
farer86733143fa__rer
favored1455983favored
favorers1465493favorers
favourer1443823favourer
flabbier1534093flabbier
flavored1554573flavored
flavorers1563983flavorers
floorer10248073floorer
gabber114916603gab_ber
gabbier12379633gabbier
gabbler124013303gabbler
galore73514843galore_
galores82614323galores
gaoler73913573ga_oler
harbored1438633harbored
harborers1446913harborers
honorer1039673honorer
ignorer8276093ignorer
imbower14235653imbower
jabber173713643jab_ber
jabberer1944023jabberer
jamboree1944863jamboree
jawboner20133363jawboner
laager74312783la_ager
labara83712893labar_a
labarum1166013labarum
label75019383lab__el
labeled102510563labeled
labelers10249413labelers
labeller10248073labeller
labile8315213labile_
laboredly1542383laboredly
laboring112110143laboring
laborite10410693laborite
laborites1149253laborites
labours9349883labours
labra75415463lab_r_a
labrets939363lab_rets
labroid1038823labroid
labrum1057423lab_rum
lacer75833753la__cer
lacier84020093la_cier
lacker125325623la_cker
lacquer18135153lacquer
ladder84617623la_dder
lader65633723la__der
ladler74314933la_dler
lager65132863la__ger
lagered92311153lagered
lagger85919833la_gger
laired75216813la_ired
laker95432873la__ker
lakier104716273la_kier
lamber104418493la_mber
lambier113611633lambier
lamer75233703la__mer
lamprey1434863lamprey
lamster9109913lamster
lancer84319973la_ncer
lander74028483la_nder
landler84113203landler
langrel8107033langrel
lanker104123003la_nker
lankier113711633lankier
lanner64920593la_nner
lanose6313593lanose_
lapper104319953la_pper
lapser84113143la_pser
larder73720973la_rder
lardier83518343lardier
laree56036293la__ree
lares54852633la__res
larger74417513la_rger
larker104519243la_rker
larkier113711523larkier
laser54633323la__ser
lasher94824533la_sher
lassoer7379383lassoer
laster64830633la_ster
later54843923la__ter
lather95124353la_ther
latherer111310443latherer
lathier10310833lathier
latter65027893la_tter
lauder73815013la_uder
laugher1136603laugher
launder8309143launder
laurel649033la_urel
laveer94110423la_veer
laver85031793la__ver
lawyer12386973la_wyer
laxer125420333la__xer
layer84626473la__yer
layered11259413layered
layovers1434073layovers
lazaret16411783lazaret
lazier154214613la_zier
libber104414003lib_ber
libeler9219003libeler
liber74723613lib__er
limberer12187043limberer
lobber104016593lob_ber
lobbyer1433913lobbyer
lobster9288853lobster
loner55431033l__oner
looker104816953l_ooker
looper83817113l_ooper
looser65219943l_ooser
looter64222323l_ooter
loper75129233l__oper
lore45850353l__ore_
lores55045403l__ores
loser54728673l__oser
lover85526453l__over
lower85830413l__ower
lubber104214623lub_ber
lumberer12177583lumberer
lurer54625313l__urer
majored1735853majored
manurer938583manurer
marrer83716673ma_rrer
maturer938973maturer
nabber104913543nab_ber
nabobery1542423nabobery
paperer113111903paperer
parer75839903pa__rer
poorer82613993_poorer
rabbler113514093rabbler
rarer54731703ra__rer
razored1736333razored
rebore86625643rebore_
rebored105015883rebored
rebores95319163rebores
saber75330243sab__er
sabered103213023sabered
saboteur1041993saboteur
sabre74821503sab_re_
sabred95916533sab_red
sabres85520863sab_res
savored1158343savored
savorers1157223savorers
savorier1136643savorier
savourer1134473savourer
scorer84818253_scorer
slabber113311393slab_ber
slalomer1045033slalomer
slaverer11196993slaverer
snorer64316763_snorer
soberer93110353soberer
sorer56236573__sorer
storer64721673_storer
suborder1146663suborder
suborner1047383suborner
tabaret92717313tabaret
taber73825823tab__er
tabered103311593tabered
tabooed10267383tabooed
tabor75518393tabo__r
taborets10278063taborets
taborin92210453taborin
tabors84517093tabor_s
tabour84011313tabo_ur
taboured1156273taboured
tabourers1144673tabourers
tabouret1049173tabouret
tambourer1343493tambourer
taperer92511793taperer
unlabored1243803unlabored
upbore10247883upbore_
vapored1336923vapored
vaporers1336243vaporers
vapourer1344263vapourer
wabbler143511923wabbler
wagerer11328493wagerer
wagoner1136083wagoner
waterer103314073waterer
waverer13319523waverer
yabber136111833yab_ber
yarer84321573ya__rer

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 Limit1340272827.25018486.5
3Display Results2822820.1901484.2
 (SQL Overall)1786912827.59623524.4
 
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.