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

213 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
rumours97637(None) 
humours1286431humours
rumors81110401rumo_rs
rumour8127381rumour_
tumours976751tumours
amours83512662_amours
armours9389852armours
brumous11107442brumou_s
grumous1086612grumou_s
humors11129632humo_rs
humour11116752humour_
ramous8417112ramou_s
repours9310232repours
rigours8207002rigours
rimous8311912rimou_s
rubouts937982rubouts
rufous948272rufou_s
rugous739652rugou_s
rummers113513652rummers
rumor71011322rumo_r_
rumoured1143782rumoured
rumpus10458892rumpu_s
runouts737352runouts
tumors8810612tumo_rs
tumour8137402tumour_
amour75014853_amour_
arbours93910043arbours
ardours8368883ardours
armors85017813armo_rs
armour84411853armour_
armoury12376233armoury
augurs7399963au_gurs
aurous64119263aurou_s
auteurs7137503auteurs
awmous1157713awmou_s
bugouts1036193bugouts
bulgurs10397113bulgurs
bummers133712443bummers
bumpers133912053bumpers
buyouts1235203buyouts
clamours1255993clamours
clours85215093_clours
colours95913443colours
comous10816503comou_s
crumbers14338243crumbers
crumbums1642733crumbums
cruors838643cru_o_rs
cumbers134515413cumbers
cummers133713483cummers
cutouts938033cutouts
cymous1388403cymou_s
demurs939773dem_urs
detours858043detours
devours1166643devours
dimouts1037893dimouts
dolours8438823dolours
drummers13316163drummers
dugouts935043dugouts
dumdums1343043dumdums
dumpers123412663dumpers
dyvours1453183dyvours
enamours1044663enamours
famous11412393famou_s
favours13437093favours
femurs1136713fem_urs
flours94414053_flours
fours85521493__fours
fucous11399863fucou_s
fumers113613383fum_ers
furors9310953furo_rs
giaours834573giaours
glamours1184733glamours
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
paramours1345653paramours
pours74623183__pours
pumpers133113673pumpers
putouts937083putouts
ragouts838543ragouts
rammers113715043rammers
ramonas9311093ramonas
ramus76418283ram_u_s
rancours1076713rancours
raucous938303raucou_s
razors154711663razo_rs
recoups1188843recoups
recourse1038383recourse
recurs83315803r_ecurs
redouts81411663redouts
remolds10299703remolds
remora8414593remo_ra
remoras9314073remoras
remorse9311713remo_rse
remotes94521613remotes
remount9512283remount
remounts1036373remounts
removers13449223removers
removes124514713removes
repour8310993repour_
rigors72813713rigo_rs
rigour7258023rigour_
rimers84522553rim_ers
rimmers113812883rimmers
roars55622243r__oars
rompers113412243rompers
roomers95416413roomers
rotors64917953roto_rs
roues56039353r__oues
roups75118903r__oups
routs57133413r__outs
rubbers113913193rubbers
rubious938283rubiou_s
ruboffs1543123ruboffs
rubout8313563rubou_t
rubus76415063ru_bu_s
ruckus12407793rucku_s
rudders93210653rudders
ruers515019413ru__ers
ruggers94612313ruggers
rugolas836373rugolas
rugosas844973rugosas
ruiners74213023ruiners
ruinous739763ruinou_s
rulers64317093ru_lers
rumakis1335533rumakis
rumbas102512013rum_bas
rumblers123610743rumblers
rumbles114018393rumbles
rumens83611813rum_ens
rummer104715483rummer_
rummies113212793rummies
rumored1046643rumored
rumouring1244513rumouring
rumples113313133rumples
rumps95922293rum__ps
rumpuses1235163rumpuses
rums64833473rum___s
runners74212453runners
runoffs1343013runoffs
runout6414873runou_t
runovers1134473runovers
rupture966163rupture
ruptures1056683ruptures
rushers103816103rushers
samburs11369343samburs
sapours93610623sapours
savours10389343savours
scours84913593_scours
sours55230503__sours
spumous1135853spumou_s
stours65015633_stours
strumous1045733strumou_s
succours1244593succours
sudors7311103sudo_rs
sulfurs1037343sulfurs
summers113616503summers
sumos75720093sumo__s
tabours94110093tabours
tambours1255873tambours
tamburs11288613tamburs
tenours72610073tenours
tours55325893__tours
tremors93711233tremo_rs
tumor71110693tumo_r_
tussurs7356393tussurs
tutors6912333tuto_rs
umbers104215213_umbers
unmoors945903unmoors
valours10248743valours
vapours12277463vapours
velours10278083velours
vigours11285483vigours
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 Limit1340272136.90619407.3
3Display Results2132130.0802662.5
 (SQL Overall)1786912137.39224173.6
 
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.