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

287 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
mano6653679(None) 
fano75831681fano
mako105622351mako
man57465851man_
mana65341941mana
mane65052011mane
mango85724311mango
manor78023921manor
manos74933611manos
mans66354531mans
many95731841many
mayo96524291mayo
meno66031351meno
mono66036711mono
abo59045962_abo
ado49146872_ado
ago48845522_ago
ambo88225132ambo
amino75425492amino
ammo85520132ammo
amnio75218042amnio
an211879072_an_
ana39559822_ana
and47244162_and
ane37866942_ane
ani37751172_ani
anoa45634472_anoa
anon46134852_anon
ant37270782_ant
any68440482_any
apo511142122_apo
avo68936232_avo
azo128233392_azo
ban58366832ban_
banco94019392banco
band76740902band
bane65250422bane
bang74836992bang
bani65334952bani
banjo143812442banjo
bank105835742bank
bans66555132bans
beano75421552beano
calo64936442calo
camo85731752camo
can57760132can_
cane66653112cane
canoe75627252canoe
canon74725302canon
cans65050842cans
canso75019402canso
cant66362022cant
canto74931012canto
capo85829212capo
cyano105512492cyano
dado67126332dado
dago65725082dago
dan46859662dan_
dang65131532dang
danio6319782danio
dank95828232dank
dans56748142dans
dato56129942dato
dino56036752dino
fado87226462fado
fan67158852fan_
fane75343562fane
fang85432542fang
fanon84619012fanon
fanos85926502fanos
fans76247362fans
faro76136922faro
fino76034692fino
gan48060122gan_
gane55145292gane
gang66031962gang
ganof95420362ganof
guano69213982guano
halo76437322halo
hand86833702hand
hang85535542hang
hank115134132hank
hant75461582hant
hao67251122ha_o
imago8118682imago
imino74315212imino
jane115031472jane
jato115822682jato
kana85928522kana
kane85133962kane
kaon87521022kaon
kayo116417552kayo
keno87926432keno
kino86233612kino
land56337302land
lane45153322lane
lang56637372lang
lank84734442lank
leno47331392leno
lino46343372lino
llano5910602llano
ma410060652ma__
maar66025052maar
mabe85733342mabe
mac78053922ma_c
mace87345782mace
mach116134472mach
macho126120152macho
mack125733642mack
macon94519952macon
macro94718172macro
macs86742502macs
mad68958702ma_d
made75440232made
mads76845362mads
mae57659102ma_e
maes66948392maes
mag67956472ma_g
mage75739122mage
magi76329522magi
magot8326392magot
mags75444522mags
mahoe10315572mahoe
maid75537632maid
mail65543432mail
maim85831472maim
main65345502main
mains75635092mains
mair66133762mair
major145212922major
make105537882make
makos116518362makos
male66052292male
mall64639362mall
malm85129972malm
malt66254802malt
mama86231582mama
mambo115215732mambo
manas76240422manas
manat76039982manat
maned86634092maned
manes76648952manes
manga85026192manga
mange84930182mange
mangos94319332mangos
mangy115021232mangy
mania75634142mania
manic94629432manic
manioc103914822manioc
manito8518692manito
manly105022942manly
manna75522532manna
manors84420882manors
manse75528222manse
manta75629902manta
manus75924922manus
map77255112ma_p
maps86141042maps
mar57965942ma_r
mara67444562mara
marc87034622marc
mare64759322mare
mark105138052mark
marl66341612marl
mars66261862mars
mart66865972mart
mas58175812ma_s
masa65034712masa
mash96039392mash
mask105227352mask
mason74820182mason
mass66044932mass
mast65959952mast
mat58083932ma_t
mate65154212mate
math95437442math
mats65460282mats
matt65752652matt
matzo16312892matzo
maud75325392maud
maul64830712maul
maun65727202maun
maund85515442maund
maut65448442maut
maw87050092ma_w
mawn94424132mawn
maws96437132maws
max129045442ma_x
maxi137023552maxi
may88757622ma_y
maya95824582maya
mayor106616622mayor
mayos105521932mayos
mays96940022mays
maze155434972maze
mazy186419692mazy
mean65538082mean_
means75831222means
meant76537202meant
meany104620472meany
memo85924792memo
men59252842men_
mend75334022mend
menu65130222menu
mho86624622m_ho
milo65536092milo
mina65136902mina
mind75434362mind
mine67256152mine
mini65634542mini
mink106636512mink
minor74920062minor
mint66758042mint
minx137723332minx
miso67229892miso
mo49158482m__o
moan65832012moan_
moans74624362moans
mojo136917222mojo
mon57561572mon_
mondo85721232mondo
mongo810122412mongo
monk105928512monk
monos75930862monos
mons68152252mons
mony96830002mony
moo58460512m_oo
moon67140812moon
mozo157719742mozo
mun56143852mun_
mungo84916052mungo
muni65824402muni
muns65535912muns
muon65722732muon
myna95815292myna
nan37854872nan_
nana46632892nana
nans46139392nans
no29353242__no
ono36838032_ono
pan58466442pan_
pane64950282pane
pang75336282pang
pans65855722pans
pant66061252pant
panto76129412panto
piano76118712piano
ran38266612ran_
rand55839562rand
rang56939152rang
rani46640102rani
rank85135522rank
rant45864672rant
rato45436972rato
romano84912942romano
sago56332672sago
sand55338462sand
sane45954332sane
sang55441222sang
sank85236822sank
sans45153352sans
santo56227282santo
taco67031352taco
tan37167562tan_
tang56138662tang
tango66921172tango
tank85134012tank
tans46154812tans
tanto55724942tanto
tao38358952ta_o
taro46846912taro
van66246322van_
vane75534682vane
vang84926032vang
vans76236722vans
vino76128432vino
wan66761932wan_
wand85833872wand
wane76344712wane
wank115632502wank
wans76452262wans
want76156162want
wany106432352wany
wino75933612wino
yang85626062yang
yank115423662yank
zany167316982zany

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 Filter178691298720.0802233637.5
2DLD Change Limit298722870.97030795.9
3Display Results2872870.0763776.3
 (SQL Overall)1786912871.126158695.4
 
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.