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

291 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
tabours9411009(None) 
labours9349891labours
tabors84517111tabo_rs
tabour84011321tabour_
tambours1255871tambours
amours83512662_amours
arbours93910042arbours
favours13437092favours
harbours1346922harbours
labors84016412labo_rs
labour84210932labour_
sapours93610622sapours
savours10389342savours
tabers84621572tab_ers
taboos83815432tabo_os
tabor75518392tabo_r_
taborers10268332taborers
tabouli945842tabouli
taboulis1045042taboulis
taboured1156272taboured
tabourer1035742tabourer
tabourers1144672tabourers
tabouret1049172tabouret
tabourets1144162tabourets
tabuns8489222tab_uns
tabus74820922tab_u_s
tambour1136352tambour_
tamboura1253892tamboura
tambouras1343492tambouras
tamburs11288612tamburs
tenours72610072tenours
tours55325892t__ours
tumours976752tumours
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
amour75014853_amour_
arbors84717883arbo_rs
arbour84211333arbour_
ardours8368883ardours
armours9389853armours
augurs7399963_augurs
babools11319453babools
baboons113211083baboons
baboos103517013babo_os
babuls105413643bab_uls
babus95620333bab_u_s
bayous11411153bayou_s
belabours1343543belabours
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
clamours1255993clamours
clours85215093_clours
colours95913443colours
dabbers123813213dabbers
detours858043detours
devours1166643devours
dolours8438823dolours
dyvours1453183dyvours
enamours1044663enamours
fablers124812613fablers
faitours1134263faitours
famous11412393famou_s
faubourg1461693faubourg
faubourgs1541233faubourgs
favors124211403favo_rs
favour12438333favour_
flavours1434693flavours
flours94414053_flours
fours85521493__fours
gabbers124612833gabbers
gaboons10289903gaboons
gators74115833gato_rs
gaurs66317993ga__urs
giaours834573giaours
glamours1184733glamours
haboobs1495463haboobs
habus106317143hab_u_s
harbors12412413harbo_rs
harbour1247053harbour_
haviours1443843haviours
honours10339373honours
hours85422393__hours
humours1286433humours
inpours936423inpours
jabbers183610583jabbers
jabirus1694573jabirus
jabots1538883jabo_ts
kabars124513953kab_ars
kabobs14439303kabo_bs
labor75117313labo_r_
laborers10208383laborers
laboured1156323laboured
labourer1045753labourer
labourers1144713labourers
labrums1175853labrums
langurs889103langurs
layouts1046483layouts
lours55125293__lours
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
sours55230503__sours
stabbers12268733stabbers
stablers103611153stablers
stators73915583stato_rs
stours65015633_stours
tabard9313333tab_ard
tabards10310383tabards
tabbies112913503tabbies
tabbis102910863tab_bis
taber73825823tab_er_
tabes76033923tab__es
tablas83716163tab_las
tables84524893tab_les
tablets94714383tablets
tabloids1146163tabloids
taboo73418093tabo__o
tabooed10267383tabooed
tabored102810563tabored
taborer9269293taborer
taboret92916113taboret
taborets10278063taborets
taborin92210453taborin
taborins103310223taborins
tabouleh1342793tabouleh
taboulehs1441973taboulehs
tabouring1245723tabouring
tabs66842983tab___s
tabu66328493tab_u__
tabued94310403tab_ued
tabuli839363tab_uli
tabulis938833tabulis
tabun75914373tab_u_n
tackers134319623tackers
tacos77023553taco__s
tagboard1245563tagboard
tagboards1345133tagboards
taggers93514193taggers
tahrs85412333ta__hrs
tailers73720183tailers
tailors73212393tailors
takeouts1245363takeouts
takers103923743ta_kers
takeups1333403takeups
talars66021683ta_lars
talcous939483talcou_s
talcums1135513talcums
talers64628143ta_lers
talkers113513213talkers
talons64019443talo_ns
taluks10418283ta_luks
talus55423263ta_lu_s
tamboured1443783tamboured
tambourer1343493tambourer
tambourers1442743tambourers
tambourin1363613tambourin
tambourins1443483tambourins
tambur10358713tambur_
tambura11326463tambura
tamburas12316053tamburas
tamers84224033ta_mers
tampers113516743tampers
tandoors9258053tandoors
tankers113416913tankers
tanners74018393tanners
taos45541003ta_o__s
tapers84025813ta_pers
tapirs84113173ta_pirs
tappers113416543tappers
tarocs84615663taro_cs
taroks106115283taro_ks
taros55640823taro__s
tarots66422993taro_ts
tars46763953ta___rs
tarsus6310513tarsu_s
tartars73313403tartars
tasters74225643tasters
tatars64619793ta_tars
taters64932203ta_ters
tatouay1044113tatouay
tatouays1142563tatouays
tatters74520483tatters
tauons63412673tauo_ns
taus46342733ta__u_s
tauts56125513ta__uts
tawers94118603ta_wers
taxers134015283ta_xers
taxols13328633taxo_ls
taxons134211503taxo_ns
taxus125512483ta_xu_s
teaboard1146293teaboard
teaboards1245393teaboards
teabowls1343463teabowls
teaboxes1745063teaboxes
tenors63217753teno_rs
tenour62610733tenour_
thous86017263t_hou_s
torous64319033torou_s
torrs53923563t__orrs
tors46157383t__o_rs
torus54329763t__orus
tour45530383t__our_
touts54830393t__outs
trouts66116633t_routs
tryouts1035313tryouts
tsouris735153t_souris
tubbers113411253tubbers
tubers85017033tub_ers
tubfuls1245483tubfuls
tumors8810613tumo_rs
tumour8137403tumour_
tussurs7356393tussurs
tutors6912333tuto_rs
valors93413773valo_rs
valour93010373valour_
vapors113812693vapo_rs
vapour11378873vapour_
vapoury15284803vapoury
velours10278083velours
vigours11285483vigours
yabbers14389353yabbers
yours85217883__yours

Search took 7 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 Limit1340272915.95322514.2
3Display Results2912910.0933129.0
 (SQL Overall)1786912916.45227695.4
 
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.