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

392 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
dammar1143890(None) 
damar84117731da_mar
dammars12308191dammars
dammer114317931dammer
daman84821162da_man
damars93814992da_mars
dammed124214792dammed
dammers123214272dammers
dammit11311132dammit
damner95213432damner
damper114117752damper
darbar959952darbar
daymare1375632daymare
dimmer114112612dimmer
gamma106116102gamma_
gammas115714692gammas
gammer1112318332gammer
grammar12406892grammar
hammal134512062hammal
hammam12419332hammam
hammer138120032hammer
jammer174014132jammer
mamma86317912mamma_
mammae94613212mammae
mammal95112752mammal
mammary1335992mammary
mammas94616402mammas
mammer94218862mammer
palmar104113462palmar
rammer103519652rammer
sambar103914162sambar
yammer133713182yammer
adman84517903_adman
afar76720783_a_far
agar58726413_a_gar
agma77623263_agma_
agmas85919873_agmas
aimer75926823_aimer
ajar116217703_a_jar
alar46340073_a_lar
alma66333023_alma_
almah106917253_almah
almas76629773_almas
almemar1144303almemar
altar55520643_altar
ama510853303_a_ma_
amah98927483_a_mah
amas67746293_a_mas
ambari103012163_ambari
ambary134010543_ambary
amber94523213_amber
ameer75618983_ameer
amia66836903_amia_
amias75831473_amias
amir65129753_a_mir
ammo85520133_amm_o
ammos94815823_ammos
amour75014853_amour
anear55420323_anear
armer76924443_armer
armor75118053_armor
atma68121773_atma_
atman75520143_atman
atmas75721013_atmas
attar56516693_attar
aurar54420253_aurar
axman144813183_axman
badman113813843badman
bagman114613813bagman
bammed133913243bammed
barman103519703barman
batman105214063batman
bayman133712703bayman
bazaar17306403bazaar
bazar163816003ba_zar
bummer124014103bummer
cabman123812503cabman
caesar8410933caesar
caiman103615663caiman
calamar1149293calamar
calcar10312753calcar
calmer105216933calmer
camas96333523ca_mas
camber124418473camber
camera10313673camera
cammie124615293cammie
camper124722213camper
carman103920743carman
caviar11310163caviar
cayman133613213cayman
chimar133911463chimar
clammer134211793clammer
comma114514793comma_
commas124814573commas
crammer134010963crammer
cummer124414593cummer
cymar125711263_cymar
dabber114816963dabber
dacha114812573dacha_
dachas124113253dachas
dacker134920753dacker
dada66422443da_da_
dadas75819863da_das
daedal849083daedal
daemon9279593daemon
dafter104813343dafter
dagga839543dagga_
daggas937973daggas
dagger95017303dagger
daiker115113033daiker
daimen92210573daimen
daimio937463daimio
daimon9259713daimon
daimyo1233193daimyo
dam67457043da_m__
damage10410773damage
damager1157973damager
damans94715983damans
damask1335843damask
dame77140313da_m_e
dames85435853da_mes
damiana1046563damiana
damming133812743damming
damn75724323da_m_n
damned104212913damned
damners104112113damners
damns84916923da_mns
damp96228843da_m_p
damped124315583damped
dampen114310593dampen
dampers123915693dampers
damply14337893damply
damps105220413da_mps
dams77444373da_m_s
damsel9148033damsel
damson938063damson
dancer94817613dancer
dander811222993dander
danger83722823danger
danker114319663danker
dapper114016633dapper
darbars10510093darbars
darer65230793da_rer
darker114718693darker
darner74017303darner
darter75320363darter
dasher104318983dasher
dastard9279703dastard
data56026653da_ta_
datary10310243da_tary
dater65332313da_ter
datura738023datura
dauber94112013dauber
daycare1355093daycare
daymares1445333daymares
daysman1335053daysman
daystar1143443daystar
deadman11238423deadman
dear55343603d__ear
debar85517863d_ebar
demark134211023d_emark
demean9510563demean
demur8311163d_emur
denar65223293d_enar
deodar837713deodar
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desman9311693desman
dewar95817733d_ewar
dharma1276103dharma_
dharmas1356503dharmas
digamma1343093digamma_
digammas1442983digammas
dimer85625603d_imer
dimmed124110323dimmed
dimmers123811563dimmers
dinar66319893d_inar
disbar938513disbar
dismal92412243dismal
dismay12229473dismay
dogear838193dogear
dogma96112463dogma_
dogmas105011243dogmas
dollar74110983dollar
dolma86214173dolma_
dolman95312403dolman
dolmas95213043dolmas
domal85619203d_omal
dormer94415893dormer
douma85817703douma_
doumas95314813doumas
drama85117413drama_
dramas95814653dramas
drammed13378073drammed
drawbar13103193drawbar
drayman1335433drayman
drear65016903d_rear
drummer12407503drummer
duma75524453d_uma_
dumas85420433d_umas
dumber114414173dumber
dumka12438833dumka_
dummy134712783dumm_y
dumper114615213dumper
durbar968723durbar
earmark1345653earmark
embar94011603_embar
emmer94314463_emmer
farmer115017373farmer
fulmar1137253fulmar
gagman103811243gagman
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamba106018513gamba_
gambas115817513gambas
gambir11509763gambir
gamer84928943ga_mer
gamier93617933gamier
gammed124216163gammed
gammers123214563gammers
gammier123711193gammier
gammon1138903gammon
gammy135514893gamm_y
gasman92911743gasman
gaydar1135503gaydar
gazar154612983ga_zar
gemma106311773gemma_
gemmae11507793gemmae
gimmal11247513gimmal
gramma11499803gramma_
grammars13345943grammars
grammas12499773grammas
gumma105313103gumma_
gummas114810513gummas
gummer114615453gummer
haar77323493ha__ar
haemal113811643haemal
halma108219253halma_
halmas117017893halmas
hamal104623103ha_mal
hammada1545083hammada
hammals14409213hammals
hammams13386433hammams
hammed144116973hammed
hammers144216053hammers
hammier143510653hammier
hammy155113433hamm_y
hamper134518653hamper
hamular1236973hamular
hamza19139773hamza_
hamzah23135553hamzah
hamzas20119013hamzas
hangar104114503hangar
harmer114719553harmer
hazmat20312263hazmat
hemmer134112643hemmer
hummer133615273hummer
jacamar1844323jacamar
jaguar1435283jaguar
jammed183811503jammed
jammers183710703jammers
jammier18408023jammier
jammy194810193jamm_y
kabar114815553ka_bar
kantar10311153kantar
karma113415003karma_
karmas123013733karmas
lahar83114263la_har
lama66635293la_ma_
lamas75532793la_mas
lamber104418493lamber
lamer75233703la_mer
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
laminar93810283laminar
lammed113915623lammed
lampad114510033lampad
lampas106615953lampas
lascar868573lascar
lawman11289053lawman
layman113511303layman
lazar144113643la_zar
lemma94811033lemma_
lemmas10349163lemmas
limmer104314793limmer
lumbar103610593lumbar
maar66025053__maar
madman113712383madman
magma104513573magma_
magmas115512503magmas
maimer104514593maimer
makar115614973ma_kar
malar76424443ma_lar
mama86231583ma_ma_
mamas95930773ma_mas
mamba116317523mamba_
mambas125716243mambas
mammals10389273mammals
mammate104411273mammate
mammati10398373mammati
mammee94417853mammee
mammers104615693mammers
mammet94319253mammet
mammey124310893mammey
mammie94313783mammie
mammon939643mammon
mammy115215163mamm_y
mamzer19459833mamzer
mar57965943___mar
mimbar1297493mimbar
momma85111053momma_
mommas94110653mommas
mummer93614543mummer
namer75622103na_mer
navar83912733na_var
nummary14314653nummary
palmary14338553palmary
palmer105816543palmer
pampa114913423pampa_
pampas124913993pampas
pamper124316663pamper
patamar1147093patamar
radar61316723ra_dar
ragman94013713ragman
ramal74622243ra_mal
rammed113117303rammed
rammers113715043rammers
rammier112811023rammier
rammy124312493ramm_y
rampart11311993rampart
rimmer103516033rimmer
rummer104715483rummer
saggar84010853saggar
samara8313853sa_mara
samba95618773samba_
sambal105215183sambal
sambars115113843sambars
sambas104219263sambas
sambhar1444853sambhar
sambur10469503sambur
samovar1244243samovar
sampan102511893sampan
samsara936913samsara
sangar73617683sangar
sansar63613393sansar
sardar73013173sardar
sarsar63011843sarsar
scammer133611973scammer
shammas14358713shammas
shammer144613143shammer
shmear1176933shmear
simar74920813_simar
simmer104115353simmer
slammer113913033slammer
smear74416393_smear
spammer133410433spammer
stammer116013343stammer
summa94713313summa_
summae103911013summae
summary14297353summary
summas104313163summas
summer104017713summer
talar56225383ta_lar
tamal73522613ta_mal
tamari8313383ta_mari
tambac122210243tambac
tambak14249263tambak
tambur10358713tambur
tamer75230103ta_mer
tammie104212683tammie
tammy124013223tamm_y
tampan102512323tampan
tamper104618513tamper
tarmac10310333tarmac
tartar63214753tartar
tatar56122063ta_tar
taxman15328613taxman
tramcar1135593tramcar
valvar12388653valvar
vamper134212653vamper
vanman1139793vanman
wadmal1237283wadmal
wammus13426733wammus
warmer113816733warmer
yammers143410323yammers
yasmak1534593yasmak
zaffar21385043zaffar
zamia165115213zamia_
zamias174212923zamias

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127163926.78316617.4
3Display Results3923920.2501568.0
 (SQL Overall)1786913927.17324911.6
 
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.