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

212 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
tumours97675(None) 
humours1286431humours
rumours976371rumours
tumors8810611tumo_rs
tumour8137401tumour_
amours83512662_amours
armours9389852armours
humors11129632humo_rs
humour11116752humour_
rumors81110402rumo_rs
rumour8127382rumour_
tabours94110092tabours
tambours1255872tambours
tamburs11288612tamburs
tenours72610072tenours
tours55325892t__ours
tumor71110692tumo_r_
tussurs7356392tussurs
tutors6912332tuto_rs
amour75014853_amour_
arbours93910043arbours
ardours8368883ardours
armors85017813armo_rs
armour84411853armour_
armoury12376233armoury
augurs7399963au_gurs
aurous64119263aurou_s
auteurs7137503auteurs
awmous1157713awmou_s
brumous11107443brumou_s
bugouts1036193bugouts
bulgurs10397113bulgurs
bummers133712443bummers
bumpers133912053bumpers
buyouts1235203buyouts
clamours1255993clamours
clours85215093_clours
colours95913443colours
comous10816503comou_s
cumbers134515413cumbers
cummers133713483cummers
cutouts938033cutouts
cymous1388403cymou_s
demurs939773dem_urs
detours858043detours
devours1166643devours
dimouts1037893dimouts
dolours8438823dolours
dugouts935043dugouts
dumdums1343043dumdums
dumpers123412663dumpers
dyvours1453183dyvours
enamours1044663enamours
famous11412393famou_s
favours13437093favours
femurs1136713fem_urs
flours94414053_flours
fours85521493__fours
fucous11399863fucou_s
fumers113613383fum_ers
furors9310953furo_rs
giaours834573giaours
glamours1184733glamours
grumous1086613grumou_s
gummers123712203gummers
gummous1236263gummou_s
honours10339373honours
hours85422393__hours
humbugs1534243humbugs
humerus1236913humerus
hummers143813063hummers
hummus1336243hummu_s
humor101110513humo_r_
humoured1444363humoured
humpers142713523humpers
humus106215073hum_u_s
inpours936423inpours
jumpers18399843jumpers
jurors1338283juro_rs
kulturs1134723kulturs
labours9349893labours
lemurs837253lem_urs
lours55125293__lours
lumbars11289763lumbars
lumbers113815913lumbers
lumpers113514483lumpers
lupous849433lupou_s
memoirs1136803memoirs
mohurs1135933__mohurs
moors74923143__moors
mors65950063__mo_rs
moues75732843__moues
mourn77215013__mourn
mourns84111013__mourns
mucors104410853muco_rs
mucous104411653mucou_s
muggurs11315103muggurs
mummers103712843mummers
mumpers133311373mumpers
mumus95517283mum_u_s
murmurs1134523murmurs
numbers113711243numbers
odours7418253_odours
osmous8138183osmou_s
ours47237563___ours
outpours1036683outpours
pours74623183__pours
pumpers133113673pumpers
putouts937083putouts
ramous8417113ramou_s
repours9310233repours
rigours8207003rigours
rimous8311913rimou_s
rubouts937983rubouts
rufous948273rufou_s
rugous739653rugou_s
rummers113513653rummers
rumor71011323rumo_r_
rumoured1143783rumoured
rumpus10458893rumpu_s
runouts737353runouts
samburs11369343samburs
sapours93610623sapours
savours10389343savours
scours84913593_scours
sours55230503__sours
spumous1135853spumou_s
stours65015633_stours
strumous1045733strumou_s
stumpers12318313stumpers
stupors935883stupo_rs
succours1244593succours
sudors7311103sudo_rs
sulfurs1037343sulfurs
summers113616503summers
sumos75720093sumo__s
tabors84517113tabo_rs
tabour84011323tabour_
tambour1136353tambour_
tamboura1253893tamboura
tambouras1343493tambouras
tambur10358713tambur_
tambura11326463tambura
tamburas12316053tamburas
tamers84224033tam_ers
tampers113516743tampers
tempers113513013tempers
tempura11295253tempura
tempuras12295063tempuras
tenors63217753teno_rs
tenour62610733tenour_
termors94712773termo_rs
thous86017263t_hou_s
thumpers15365713thumpers
timbers113111853timbers
timeous938403timeou_s
timeouts1044773timeouts
timers84420993tim_ers
torous64319033torou_s
torrs53923563t__orrs
tors46157383t__o_rs
torus54329763t__orus
tour45530383t__our_
touts54830393t__outs
tremors93711223tremo_rs
trouts66116633t_routs
tryouts1035313tryouts
tsouris735153t_souris
tubbers113411253tubbers
tubers85017033tu_bers
tubfuls1245483tubfuls
tuchuns1233983tuchuns
tuckers134014353tuckers
tufters10298353tufters
tuggers93711443tuggers
tumblers123110623tumblers
tumbles113816023tumbles
tummies113012033tummies
tummlers12295703tummlers
tumoral938133tumoral
tumorous1046603tumorous
tumps95420793tum__ps
tumuli835933tum_uli
tumulous1045303tumulou_s
tumult839703tum_ult
tumults934823tumults
tumulus935033tumulus
tuners64417343tu_ners
tuneups933333tuneups
tuques15358373tu_ques
turgors836833turgors
turmoils1043983turmoils
turners73912893turners
turnouts845413turnouts
turnups933893turnups
tuskers113710043tuskers
tussars7359253tussars
tussers74313563tussers
tussors7388773tussors
tussur6357293tussur_
tutor5712493tuto_r_
tutoyers1133303tutoyers
tutus55214813tu_tu_s
tuyers94612563tu_yers
umbers104215213_umbers
unmoors945903unmoors
utmosts934593utmosts
valours10248743valours
vapours12277463vapours
velours10278083velours
vigours11285483vigours
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.1561145455.1
2DLD Change Limit1340272126.37321030.4
3Display Results2122120.0802650.0
 (SQL Overall)1786912126.60927037.5
 
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.