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

353 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
main6534550(None) 
ain37579091_ain
amain74922881amain
amin66042241amin
cain65643911cain
fain75840561fain
gain56042161gain
kain85334291kain
lain46146281lain
maid75537631maid
mail65543431mail
maim85831471maim
mains75635091mains
mair66133761mair
man57465851ma_n
matin75132851matin
maun65727201maun
mavin105722951mavin
mawn94424131mawn
pain65647241pain
rain46251731rain
sain45551291sain
tain45548071tain
vain75233001vain
wain75840191wain
again65218112again
agin56132712agin
ai211288392_ai_
aid49269072_aid
ail37171042_ail
aim57858212_aim
ains46158882_ains
air38058392_air
airn46433832_airn
ais39083572_ais
ait38093902_ait
akin86328032akin
amen66733152amen
ami56646802ami_
amia66836892amia
amid77036332amid
amie66339842amie
amine75835372amine
amino75425492amino
amins75534312amins
amir65129742amir
amis66445312amis
an211879072_a_n
ani37751172_ani
awn68035912_awn
ayin76331742ayin
bail65042802bail
bairn77515532bairn
bait66556002bait
ban58366832ba_n
bani65334952bani
barn66444642barn
basin75026922basin
bin56658632_bin
blain75421792blain
blin67228172blin
brain76229382brain
brin67038192brin
cabin94820932cabin
caid77837532caid
cains75334302cains
cairn75717512cairn
can57760132ca_n
carn66245432carn
chain105723672chain
chin96934742chin
coin66645352coin
dais57040702dais
damn75724322damn
dan46859662da_n
darn56434622darn
dawn85624202dawn
din46459462_din
djin12911632djin
domain9511322domain
drain65222892drain
earn46737552earn
elain55324702elain
email74715092email
fagin9216572fagin
fail74840242fail
faint85837062faint
fair76332522fair
fan67158852fa_n
faun76226622faun
fawn105321952fawn
fin66458032_fin
foin77231562foin
gaen57329602gaen
gains65729512gains
gait56150192gait
gamin84422992gamin
gan48060122ga_n
gaun56427712gaun
gin46055752_gin
grain65126252grain
grin55733722grin
haen76229452haen
haik115526982haik
hail74839062hail
haint85436322haint
hair76330142hair
hin67559562_hin
in28150862__in
jail115529092jail
jin106443932_jin
join116724832join
kaif116933922kaif
kail85131492kail
kains96125642kains
kaon87521022kaon
karn86129412karn
kin76353962_kin
laic65931562laic
laid56439142laid
lair45934152lair
lapin75222922lapin
lawn75925632lawn
layin84720332layin
lin37967372_lin
loin46838722loin
ma410060652ma__
maar66025052maar
mabe85733342mabe
mac78053922ma_c
mace87345782mace
mach116134472mach
macing114221552macing
mack125733642mack
macon94519952macon
macs86742502macs
mad68958702ma_d
made75440232made
mads76845362mads
mae57659102ma_e
maes66948392maes
mafia104418032mafia
mafic125615462mafic
mag67956472ma_g
mage75739122mage
magi76329522magi
magian9312832magian
magic105818652magic
mags75444522mags
maiden93512282maiden
maids86327132maids
maile75232212maile
maill74420782maill
mails76037772mails
maims96321782maims
mainly11411492mainly
mairs76228292mairs
maist75535672maist
maize164618552maize
make105537882make
making134823842making
mako105622352mako
male66052292male
malic94525652malic
malign939852malign
maline84529082maline
malkin122913142malkin
mall64639362mall
malm85129972malm
malt66254802malt
mama86231582mama
mamie95826002mamie
mana65341942mana
mane65052012mane
mania75634142mania
manic94629432manic
manna75522532manna
mano66536792mano
mans66354532mans
many95731842many
map77255112ma_p
maps86141042maps
mar57965942ma_r
mara67444562mara
marc87034622marc
mare64759322mare
margin94016842margin
maria75032882maria
marina84623412marina
marine84230402marine
mark105138052mark
marl66341612marl
marlin84220902marlin
mars66261862mars
mart66865972mart
martin84122522martin
mas58175812ma_s
masa65034712masa
mash96039392mash
mask105227352mask
mason74820182mason
mass66044932mass
mast65959952mast
mat58083932ma_t
mate65154212mate
math95437442math
mating94832912mating
matins84527782matins
mats65460282mats
matt65752652matt
mattin84416632mattin
maud75325392maud
maul64830712maul
maund85515442maund
maut65448442maut
maven104816892maven
mavie104722562mavie
mavins115119182mavins
mavis105622722mavis
maw87050092ma_w
mawing124020802mawing
maws96437132maws
max129045442ma_x
maxi137023552maxi
maxim165216002maxim
maxing164817072maxing
maxis145721562maxis
may88757622ma_y
maya95824582maya
mayan105616902mayan
maying124421152maying
mayo96524292mayo
mays96940022mays
mayvin1436522mayvin
maze155434972maze
mazing184418972mazing
mazy186419692mazy
mean65538082mean
meiny104015402meiny
men59252842m_en
mi48249042m_i_
mib76946102m_ib
mic77647632m_ic
mid67354452m_id
mien65028352mien
mig65646072m_ig
mil55752102m_il
mim76048412m_im
mina65136902m_ina
mind75434362m_ind
mine67256152m_ine
mini65634542m_ini
mink106636512m_ink
mint66758042m_int
minx137723332m_inx
mir57046762m_ir
mirin75023142mirin
mis58162612m_is
mix126138172m_ix
moan65832012moan
moil65534082moil
mon57561572m_on
moon67140812moon
morn66237562morn
mown95424442mown
mucin93116822mucin
mun56143852m_un
muni65824402muni
muon65722732muon
naan47621932naan
naif76839012naif
nail45838652nail
nan37854872na_n
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466442pa_n
patin76832852patin
pavin105623202pavin
pawn94625302pawn
pein65834942pein
pian66136092pian
pin57066722_pin
plain74823302plain
pyin96823232pyin
qaid146023842qaid
quin135823922quin
rai37658222rai_
raia46638382raia
raid55243072raid
rail46147762rail
rains55140232rains
rainy85921082rainy
rais45252622rais
ran38266612ra_n
rani46640102rani
ravin85624652ravin
rawin85521472rawin
rein46040892rein
remain85919862remain
rin36663182_rin
ruin47430512ruin
sabin74924942sabin
said55742112said
sail45447162sail
sains55639972sains
saint55147072saint
sarin55239252sarin
sasin54626572sasin
satin55935212satin
savin84625082savin
sawn75428162sawn
shin75634302shin
sin36265892_sin
skin85927522skin
slain54923572slain
spin66231302spin
stain55727932stain
swain84919052swain
tail45443652tail
tains54936322tains
taint55542282taint
takin94921302takin
tan37167562ta_n
tarn46842722tarn
thin76732382thin
tin36362172_tin
train56529112train
twain86313622twain
twin76023082twin
tyin76424002tyin
vail75432552vail
vair75624142vair
van66246322va_n
vein75625752vein
waif105836742waif
wail75238822wail
wains86930862wains
wair75830052wair
wait75553692wait
wan66761932wa_n
warn75239322warn
whin105225692whin
win66456292_win
yarn75230042yarn
yawn106219092yawn
yin67648732_yin
zayin174512042zayin
zein135620602zein
zin125643772_zin

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.1101624463.6
2DLD Change Limit298723531.09327330.3
3Display Results3533530.1232869.9
 (SQL Overall)1786913531.326134759.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.