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

218 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
tumour813740(None) 
humour11116751humour
rumour8127381rumour
tumor71110691tumo_r
tumours976751tumours
amour75014852_amour
armour84411852armour
humor101110512humo_r
humours1286432humours
rumor71011322rumo_r
rumours976372rumours
tabour84011322tabour
tambour1136352tambour
tambur10358712tambur
tenour62610732tenour
tour45530382t__our
tumors8810612tumors
tussur6357292tussur
tutor5712492tuto_r
amours83512663_amours
arbour84211333arbour
ardour74110903ardour
armor75118053armo_r
armours9389853armours
armoury12376233armoury
augur64311213au_gur
aurous64119263aurous
auteur6107943auteur
awmous1157713awmous
brumous11107443brumous
bugout9311863bugout
bulgur9387533bulgur
bummer124014103bummer
bumper123714343bumper
buyout11310103buyout
clamour1196333clamour
clour76617283_clour
colour85915093colour
comous10816503comous
cumber124016703cumber
cummer124414593cummer
cutout8315923cutout
cymous1388403cymous
demur8311163dem_ur
detour778193detour
devour1076703devour
dimout9414243dimout
dolour75710133dolour
dour56330433__dour
dugout8310363dugout
dumber114414173dumber
dumdum1244523dumdum
dumper114615213dumper
dyvour1393343dyvour
enamour945433enamour
famous11412393famous
favour12438333favour
femur1038683fem_ur
flour84916453_flour
four76226863__four
fucous11399863fucous
fumer105918233fum_er
fumier11310903fumier
furfur1235553furfur
furor8312393furo_r
giaour735363giaour
glamour1065133glamour
grumous1086613grumous
gummer114615453gummer
gummous1236263gummous
honour94710863honour
hour75827313__hour
humbug1434803humbug
hummer133615273hummer
hummus1336243hummus
humors11129633humors
humoured1444363humoured
humper134115883humper
humus106215073hum_us
inpour837063inpour
jumper173612373jumper
juror1239563juro_r
kultur1034433kultur
labour84210933labour
lemur739773lem_ur
lour45430683__lour
lumbar103610593lumbar
lumber103817773lumber
lumper103816653lumper
lupous849433lupous
memoir1037213memoir
mohur1036513__mohur
moor66628553__moor
mor56855003__mo_r
moue65835573__moue
mourn77215013__mourn
mucor94011943muco_r
mucous104411653mucous
muggur10325593muggur
mummer93614543mummer
mumper123513523mumper
mumu86022063mum_u_
mumus95517283mum_us
murmur1034853murmur
number103913223number
odour64710493_odour
osmous8138183osmous
our36042893___our
outpour937423outpour
pour611527473__pour
pumper124415553pumper
putout8315113putout
ramous8417113ramous
repour8310993repour
rigour7258023rigour
rimous8311913rimous
rubout8313563rubout
rufous948273rufous
rugous739653rugous
rummer104715483rummer
rumors81110403rumors
rumoured1143783rumoured
rumpus10458893rumpus
runout6414873runout
sambur10469503sambur
sapour83812373sapour
savour94110703savour
scour75315533_scour
sour45935893__sour
spumous1135853spumous
stour54916743_stour
strumous1045733strumous
stumper113610093stumper
stupor836013stupo_r
succour1144693succour
sudor6312623sudo_r
sulfur937913sulfur
summer104017713summer
sumo67326313sumo__
sumos75720093sumo_s
tabor75518393tabo_r
tabours94110093tabours
tamboura1253893tamboura
tambours1255873tambours
tambura11326463tambura
tamburs11288613tamburs
tamer75230103tam_er
tamper104618513tamper
temper103914093temper
tempura11295253tempura
tenor53620253teno_r
tenours72610073tenours
termor84412513termo_r
thou76722213t_hou_
thous86017263t_hous
thumper14356953thumper
timber104012683timber
timeous938403timeous
timeout948593timeout
timer75626043tim_er
tor39261683t__o_r
torous64319033torous
torr45630903t__orr
tours55325893t__ours
tout46753823t__out
tremor84210403tremo_r
trout57332573t_rout
tryout9410753tryout
tubber104313203tubber
tuber75420683tu_ber
tubful1136683tubful
tuchun1145443tuchun
tucker124316953tucker
tufoli933973tufoli
tufter9319933tufter
tugger84013103tugger
tumble103215643tumble
tumbler113412823tumbler
tumefy1434223tumefy
tumid84114023tum_id
tummler11266613tummler
tummy124711993tum_my
tumoral938133tumoral
tumorous1046603tumorous
tump85927033tum__p
tumped114216233tumped
tumps95420793tum_ps
tumular9236543tumular
tumuli835933tumuli
tumulous1045303tumulous
tumult839703tumult
tumulus935033tumulus
tuner56022683tu_ner
tuneup835203tuneup
tuque14469193tu_que
turgor736863turgor
turmoil944723turmoil
turner63914613turner
turnout7410283turnout
turnup835093turnup
tusker104212193tusker
tussar6369543tussar
tusser64615833tusser
tussor6378233tussor
tussurs7356393tussurs
tutors6912333tutors
tutoyer1033793tutoyer
tutu48423173tu_tu_
tutus55214813tu_tus
tuyer85414293tu_yer
umber94617593_umber
unmoor836313unmoor
utmost878483utmost
valour93010373valour
vapour11378873vapour
velour9328763velour
vigour10256803vigour
your78623433__your

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162184.96622697.5
3Display Results2182180.0633460.3
 (SQL Overall)1786912185.40533060.3
 
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.