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

223 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
manus7592493(None) 
anus47131111_anus
magus85318751magus
manas76240431manas
manes76648961manes
manos74933621manos
mans66354551man_s
menus75822841menus
minus75223931minus
amus65529612_amus
anas46649862_anas
ands57833612_ands
anes45255932_anes
anis45746462_anis
ankus91410682_ankus
ants47243472_ants
babus95620332babus
bands85233432bands
banes74945582banes
bangs85627782bangs
banks115527902banks
banns75321232banns
bans66555142ban_s
bonus75324322bonus
canes75350372canes
cans65050852can_s
cants77036942cants
cantus85117762cantus
casus76419252casus
conus76726532conus
dangs75623212dangs
dans56748152dan_s
fanes84639892fanes
fangs96224082fangs
fanos85926502fanos
fans76247372fan_s
fanum10313442fanum
fanums1137262fanums
fauns84516752fauns
favus114311732favus
gangs76222582gangs
genus65319832genus
gnus56518002_gnus
habus106317142habus
hakus125114112hakus
hands95327382hands
hangs95726732hangs
hanks126226862hanks
hants86335402hants
janes124928122janes
kagus105812032kagus
kanas95326912kanas
kanes95529372kanes
kanzus1944602kanzus
lands65426902lands
lanes54946792lanes
maars74621632maars
mabes96331532mabes
maces97139962maces
machs125722562machs
macks135127602macks
macs86742512ma_cs
mads76845372ma_ds
maes66948402ma_es
mages85036022mages
magnum1136732magnum
magnums1234682magnums
mags75444532ma_gs
maids86327142maids
mails76037782mails
maims96321792maims
mains75635112mains
mairs76228302mairs
makes115336852makes
makos116518362makos
males75049792males
malls76233432malls
malms95021552malms
malts76331752malts
mamas95930772mamas
man57465872man__
mana65341962man_a
manat76039992manat
manats84623462manats
mane65052032man_e
maned86634102maned
manful11610212manful
manga85026212manga
mangas94122932mangas
mange84930202mange
manges94628952manges
mango85724332mango
mangos94319342mangos
mangy115021252mangy
mania75634152mania
manias84029032manias
manic94629442manic
manics103919932manics
manitus9310922manitus
manly105022952manly
manna75522542manna
mannas85019802mannas
mano66536812man_o
manor78023932manor
manors84420882manors
manque17259512manque
manse75528232manse
manses84225512manses
manta75629912manta
mantas85725362mantas
mantes84430782mantes
mantis83926032mantis
mantua84412022mantua
mantuas93410992mantuas
manual8313462manual
manuals9311222manuals
manure8313652manure
manures9313352manures
many95731862man_y
maps86141052ma_ps
maqui16249952maqui
maquis17249482maquis
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261872ma_rs
marts77442232marts
mas58175822ma__s
masas75630412masas
masks115320532masks
mass66044942ma_ss
masts77035762masts
mates75251362mates
maths105624022maths
mats65460292ma_ts
matts76829182matts
maud75325402ma_ud
mauds85519272mauds
maul64830722ma_ul
mauls76524952mauls
maun65727212ma_un
maund85515452maund
maunds9519652maunds
maut65448452ma_ut
mauts75927192mauts
mavis105622722mavis
maws96437142ma_ws
maxes145629532maxes
maxis145721562maxis
mayas105924382mayas
mayos105521932mayos
mays96940032ma_ys
mazes165632172mazes
means75831232mean_s
meatus85112922meatus
mends84927692mends
menu65130232menu_
meous76120062meous
miaous8511692miaous
minas75434112minas
minds85427122minds
mines75651952mines
minis75432992minis
minks115829272minks
mints76834042mints
moans74624372moan_s
modus85417202modus
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262mon_s
mucus94015742mucus
mumus95517282mumus
munis75022002munis
muns65535922mun_s
mus55946752m__us
mynas105815232mynas
nanas55928632nanas
nans46139402nan_s
nus37939392__nus
onus45826812_onus
panes76148692panes
pangs84628672pangs
pans65855732pan_s
pants76536922pants
rakus94413672rakus
ramus76418282ramus
rands65930452rands
ranis55235832ranis
ranks95225732ranks
rants55935342rants
sands65228582sands
sanes55649072sanes
sans45153362san_s
sinus55523852sinus
tabus74820922tabus
talus55423262talus
tangs65028362tangs
tanks94624742tanks
tans46154832tan_s
taus46342732ta_us
taxus125512482taxus
tonus56324302tonus
unaus53216572unaus
vagus96713812vagus
vanes85130972vanes
vangs96319592vangs
vans76236732van_s
varus85921182varus
vatus86114642vatus
vaus75928922va_us
venus84918902venus
wamus105514682wamus
wands96425482wands
wanes85040882wanes
wanks126124482wanks
wans76452272wan_s
wants87932212wants
yangs95618702yangs
yanks125316572yanks

Search took 2 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.313570897.8
2DLD Change Limit538002231.46636698.5
3Display Results2232230.0633539.7
 (SQL Overall)1786912231.84297009.2
 
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.