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 “ramus” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

176 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
ramus7641828(None) 
amus65529611_amus
rakus94413671rakus
ramous8417101ramous
ramps96224631ramps
rams65950771ram_s
wamus105514681wamus
amas67746292_amas
amis66445312_amis
amps86230342_amps
amu58237322_amu_
amuse75920832_amuse
anus47131112_anus
arames84622572arames
arcus76918862arcus
argus66716542argus
arms66137492arm_s
arums75517832arums
babus95620332babus
bams87044452bam_s
camas96333522camas
cames97047312cames
camos95927612camos
camps116330262camps
campus125213922campus
cams87047282cam_s
casus76419252casus
cramps125615562cramps
crams96229152cram_s
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372dam_s
dramas95814652dramas
drams86025832dram_s
emus66821682_emus
fames105735922fames
famous11412392famous
favus114311732favus
frames115119862frames
gamas85431352gamas
gambs105721122gambs
games86238552games
gamps105323712gamps
gams76648882gam_s
gamut8322982gamut
gamuts958782gamuts
gaums86217072gaums
gradus84411212gradus
gramas94317202gramas
gramps114114272gramps
grampus12356312grampus
grams85327312gram_s
habus106317142habus
hakus125114112hakus
hames106138702hames
hams96446132ham_s
humus106215072humus
iambs95815052iambs
iambus10468892iambus
jambs166014622jambs
jams135231072jam_s
kagus105812032kagus
kames115024692kames
lamas75532792lamas
lambs95921412lambs
lames75445542lames
lamps95624832lamps
lams66552262lam_s
magus85318752magus
mamas95930772mamas
manus75924922manus
momus96116112momus
mumus95517282mumus
mus55946752__mus
names74833362names
pams85641762pam_s
prahus11458242prahus
prams96125512pram_s
praus74621752pra_us
primus103712172primus
races74943242races
racks115028852racks
radius73914862radius
rads56046602ra_ds
raffs115017522raffs
rafts87820632rafts
ragas65326062ragas
rages64539442rages
raggs75216472raggs
ragis66325602ragis
rags55448372ra_gs
raias54631122raias
raids65827512raids
rails55937402rails
rains55140232rains
rais45252622ra_is
rajas127317722rajas
rajes125022782rajes
rakes94440352rakes
rakis95323442rakis
raku85423772raku_
rales54947492rales
ram56867272ram__
ramal74622242ramal
ramee74633852ramee
ramees84620892ramees
ramen75625192ramen
ramet75743142ramet
ramets83517392ramets
rami66034092ram_i
ramie75027822ramie
ramies84630462ramies
rammy124312492rammy
ramose8314402ramose
ramp85934002ram_p
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rants55935342rants
rapes75740722rapes
raps66247732ra_ps
rares55247442rares
ras37575392ra__s
rases55447212rases
rasps74316662rasps
rates55352012rates
ratos55528762ratos
rats46260372ra_ts
raves85441972raves
raws75238212ra_ws
raxes124729392raxes
rayas85922052rayas
rays77642352ra_ys
razes145032702razes
reams75729622ream_s
rebus75721112rebus
rems66237722rem_s
rhamnus1233132rhamnus
rhus75114052r_hus
rimes75634542rimes
rimous8311912rimous
rims65936302rim_s
risus54216392risus
roams74919612roam_s
romps94617542romps
roms67038962rom_s
rubus76415052rubus
rumps95922292rumps
rumpus10458892rumpus
rums64833472rum_s
samps96124672samps
shamus114112812shamus
tabus74820922tabus
talus55423262talus
tames75242012tames
tamis76728722tamis
tamps95524082tamps
tams67247932tam_s
taus46342732ta_us
taxus125512482taxus
tragus749222tragus
tramps105114452tramps
trams75327672tram_s
uraeus638792uraeus
vagus96713812vagus
vamps125415482vamps
varus85921182varus
vatus86114642vatus
vaus75928922va_us
wames106432802wames
wammus13426732wammus
wampus13499012wampus
yams95330732yam_s
yamun10419272yamun
yamuns11336512yamuns

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 Filter178691538000.203880251.2
2DLD Change Limit538001765.4869806.8
3Display Results1761760.0901955.6
 (SQL Overall)1786911765.77930920.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.