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 “labours” 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
labours934989(None) 
labors84016411labo_rs
labour84210931labour_
tabours94110091tabours
amours83512662_amours
arbours93910042arbours
belabours1343542belabours
clamours1255992clamours
favours13437092favours
flavours1434692flavours
glamours1184732glamours
harbours1346922harbours
labor75117312labo_r_
laborers10208382laborers
laboured1156322laboured
labourer1045752labourer
labourers1144712labourers
labrums1175852labrums
langurs889102langurs
layouts1046482layouts
lours55125292l__ours
sapours93610622sapours
savours10389342savours
tabors84517112tabo_rs
tabour84011322tabour_
tambours1255872tambours
valours10248742valours
vapours12277462vapours
abhors11410623_abhors
abjure1536743_abjure
abjures1636523_abjures
aboard9312613_aboard
abodes94417513_abodes
abohms1335003_abohms
abomas101113583_abomas
abort76133583_abo_rt
aborts84916183_aborts
abos67734413_abo__s
abound9239863_abound
abounds10217083_abounds
about75229083_abou_t
aboves114512843_aboves
absurd935903_absurd
absurds1035003_absurds
abuts75417073_ab_uts
albums10198273alb_ums
algors7312553algo_rs
amour75014853_amour_
arbors84717883arbo_rs
arbour84211333arbour_
ardours8368883ardours
armours9389853armours
augurs7399963_augurs
babools11319453babools
baboons113211083baboons
baboos103517013babo_os
babuls105413643bab_uls
babus95620333bab_u_s
bayous11411153bayou_s
belabors1236403belabo_rs
belabour1243773belabour_
blabbers11308153blabbers
blurs74619083__blurs
boars75229603__boars
boors74325013__boors
bourg84113843__bourg
bourgs9459993__bourgs
bourn75518483__bourn
bourns84114063__bourns
bourse84414333__bourse
bouts75131313__bouts
burs65847423__b_urs
cabers105023923cab_ers
cablers114416713cablers
cabobs124311893cabo_bs
candours11408643candours
canoers94318373canoers
chabouks1943823chabouks
clabbers14359903clabbers
clamors11710093clamo_rs
clamour1196333clamour_
clangours12263123clangours
clours85215093_clours
colours95913443colours
dabbers123813213dabbers
detours858043detours
devours1166643devours
dolours8438823dolours
dyvours1453183dyvours
enamours1044663enamours
fablers124812613fablers
faitours1134263faitours
famous11412393famou_s
faubourg1461693faubourg
faubourgs1541233faubourgs
favors124211403favo_rs
favour12438333favour_
flaneurs1133953flaneurs
flavors1337293flavo_rs
flavour1334633flavour_
flavoury1743063flavoury
flours94414053_flours
fours85521493__fours
gabbers124612833gabbers
gaboons10289903gaboons
gators74115833gato_rs
gaurs66317993ga__urs
giaours834573giaours
glabrous1145533glabrou_s
glamors1068113glamo_rs
glamour1065133glamour_
globous1036503globou_s
haboobs1495463haboobs
habus106317143hab_u_s
harbors12412413harbo_rs
harbour1247053harbour_
haviours1443843haviours
honours10339373honours
hours85422393__hours
humours1286433humours
inpours936423inpours
jabbers183610583jabbers
jabirus1694573jabirus
jabots1538883jabo_ts
kabars124513953kab_ars
kabobs14439303kabo_bs
laagers83411253laagers
labara83712893lab_ara
labarum1166013labarum
labarums1254503labarums
labelers10249413labelers
labels84515683lab_els
labials9299873labials
labium10410243labiu_m
labored102810243labored
laborer9249503laborer
labouring1236213labouring
labra75415463lab__ra
labrets939363labrets
labroids1155843labroids
labrum1057423labru_m
labs67145123lab___s
lacers85225253la_cers
lackers134120543lackers
lacquers19125033lacquers
ladders94115173ladders
laders74927763la_ders
ladlers84613563ladlers
lagers74826143la_gers
laggers94216243laggers
lagoons839253lagoons
lahars94013163la_hars
lairs55425873la__irs
lakers105225153la_kers
lambers113817113lambers
lampers113817333lampers
lancers93616643lancers
landers84026213landers
langues81211913langues
languors976153languors
langur7109303langur_
lanners73618333lanners
lapboard1355783lapboard
lapboards14105373lapboards
lapfuls1234503lapfuls
lappers113717463lappers
lapsers93911053lapsers
lapsus8437273lapsu_s
larboard1157663larboard
larboards1246983larboards
larders83516943larders
larkers113014513larkers
larrups934733larrups
lars46956573la___rs
larums83610533la_rums
lascars979013lascars
lasers64925703la_sers
lashers104121833lashers
lassoers8338513lassoers
lasters75627693lasters
lathers104321883lathers
lauders84012893lauders
lauds65618483la__uds
laura54116203la__ura
lauras63414333la__uras
laveers10329363laveers
lavers94526363la_vers
lawbooks1743743lawbooks
lawyers13377153lawyers
layabouts1442573layabouts
layers93921183la_yers
layoffs1642573layoffs
layout9513703layou_t
layovers1434073layovers
layups1133993la_yups
lazars153812393la_zars
lemurs837253l_emurs
libbers113812833libbers
libers84721443lib_ers
liquors1634433liquors
lobbers113713943lobbers
lobos75921843lobo__s
louis57322323l__ouis
loups75319623l__oups
lour45430683l__our_
loury85716753l__oury
louts56330273l__outs
lubbers113913723lubbers
lupous849433lupou_s
mahouts1237143mahouts
majors154511093majo_rs
manors84420883mano_rs
mayors115714193mayo_rs
nabbers113710463nabbers
nabobs10388213nabo_bs
odours7418253_odours
ours47237563___ours
pablums1345123pablums
padouks1434873padouks
pandours11317993pandours
parlours1036153parlours
parous84024163parou_s
paviours1343613paviours
payors114312643payo_rs
payouts1247303payouts
pours74623183__pours
ragouts838543ragouts
ramous8417113ramou_s
rancours1076713rancours
razors154711663razo_rs
repours9310233repours
rigours8207003rigours
rubouts937983rubouts
rumours976373rumours
sabers85224733sab_ers
sabirs85414633sab_irs
saboteurs1141863saboteurs
sabots8314703sabo_ts
sajous13310583sajou_s
sambhurs1543183sambhurs
samburs11369343samburs
santours837183santours
santurs7310763santurs
sapors84118813sapo_rs
sapour83812373sapour_
saviours1154273saviours
savors95616103savo_rs
savour94110703savour_
savoury13365873savoury
scours84913593_scours
slabbers123610123slabbers
sours55230503__sours
stours65015633_stours
tabers84621573tab_ers
taboos83815433tabo_os
tabor75518393tabo_r_
taborers10268333taborers
tabouli945843tabouli
taboulis1045043taboulis
taboured1156273taboured
tabourer1035743tabourer
tabourers1144673tabourers
tabouret1049173tabouret
tabourets1144163tabourets
tabuns8489223tab_uns
tabus74820923tab_u_s
tambour1136353tambour_
tamboura1253893tamboura
tambouras1343493tambouras
tamburs11288613tamburs
tenours72610073tenours
tours55325893__tours
tumours976753tumours
valors93413773valo_rs
valour93010373valour_
vapors113812693vapo_rs
vapour11378873vapour_
vapoury15284803vapoury
velours10278083velours
vigours11285483vigours
yabbers14389353yabbers
yours85217883__yours

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.406440125.6
2DLD Change Limit1340272826.89319443.9
3Display Results2822820.1062660.4
 (SQL Overall)1786912827.40524131.1
 
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.