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

266 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
sunnah936935(None) 
sunna55016061sunna_
sunnahs10326591sunnahs
sunnas63914561sunnas
punkah15347092punkah
senna54617982senna_
sennas64214232sennas
subah106015212su_bah
succah1336642succah
sukkah12123732sukkah
sunbath1236422sunbath
sundae7312872sundae
sunn45423592sunn__
sunned74216322sunned
sunns55017352sunn_s
sunny84917742sunn_y
sunray9310122sunray
suntan62613002suntan
surah86823252su_rah
anna45529013_anna_
annal56520763_annal
annas55824883_annas
buna64730723bu_na_
bunas75126573bu_nas
bunch125118603bu_nch
bunn65023653bunn__
bunns74718293bunn_s
bunny104715803bunn_y
bunya103810093bunya_
bunyas11359433bunyas
canna75919333canna_
cannas84518403cannas
cuneal8611513cuneal
cunner83915003cunner
donna66215033donna_
donnas75511323donnas
duenna734593duenna_
duennas834143duennas
dunam8313733du_nam
dunch115316263du_nch
dunnage9175213dunnage
dunned85015523dunned
dunner73913823dunner
eunuch1154363eunuch
fungal10388733fungal
funned103613953funned
funnel93610743funnel
funner93414103funner
funny114614833funn_y
ganjah17145493ganjah
guanay1037913guanay
gunman9299453gunman
gunned83513093gunned
gunnel73411053gunnel
gunnen7338713gunnen
gunner73813983gunner
gunny94413663gunn_y
henna84414043henna_
hennas94211803hennas
hosannah1441863hosannah
hunch136416213hu_nch
hunh106323733hu_n_h
hunnish1336163hunnish
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
jubbah2034353jubbah
jubhah2142803jubhah
junta123713673junta_
juntas134210503juntas
kuna85120703ku_na_
luna46229853lu_na_
lunar57017313lu_nar
lunas55025013lu_nas
lunch104917243lu_nch
lungan74710213lungan
manna75522533manna_
mannan85413623mannan
mannas85019803mannas
mullah113710733mullah
munch124917103mu_nch
mynah13569563_mynah
nah69847003___nah
nullah9388143nullah
nunnish1035933nunnish
penna74520203penna_
pennae84314033pennae
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pujah17478543pu_jah
puna65331653pu_na_
punas74826753pu_nas
punch125118423pu_nch
punish111411503punish
punka114515483punka_
punkahs16284783punkahs
punkas123410673punkas
punned93416193punned
punner84918153punner
punnet83518843punnet
punny104217713punn_y
purdah12288753purdah
quench2036633quench
quinnat16116823quinnat
ruana5312423ruana_
ruanas6311263ruanas
runnel63510663runnel
runner63814463runner
runny84613483runn_y
runway12105973runway
rupiah1146213rupiah
sandal73317283sandal
sanga66023793sanga_
sangar73617683sangar
sangas75222653sangas
sangh95517453s_angh
sanjak1735693sanjak
sannop837373sannop
sannup836563sannup
sansar63613393sansar
sauna54117553sauna_
saunas63915433saunas
savannah1441953savannah
scena74815783scena_
scenas84114703scenas
scunner9358243scunner
selah8319613s_elah
sendal73314993sendal
sennet64224143sennet
sennit63117923sennit
sensa54117473sensa_
shah105627783s__hah
shibah14387463shibah
shivah15488533shivah
shunned11417843shunned
shunner10358643shunner
sienna647193sienna_
siennas736123siennas
signa66114703signa_
signal73711483signal
sinh76238043s_in_h
sinned73818413sinned
sinner64320603sinner
sirrah9379753sirrah
snag55827873s__nag
snap65727033s__nap
snash84815673s_nash
snath86419803s_nath
snaw78923073s__naw
sneak96016173s_neak
sneap75514823s_neap
sonant6621953sonant
sonar56523423s_onar
sonnet65923503sonnet
sonny85016103sonn_y
spinach1435393spinach
spinal84915313spinal
squinch2134833squinch
stanch113812373stanch
stench114111163stench
stengah1144553stengah
stunned8358893stunned
stunner7349193stunner
suba64926603su_ba_
subahs114512383su_bahs
subas74724073su_bas
subnet82520933subnet
subpar1048663subpar
subway1447073subway
succahs1435323succahs
such96424813su__ch
sugar6312913su_gar
sugh86423443su__gh
suing65026363suin_g
suint55638183suin_t
suints64617783suints
sukkahs1382703sukkahs
sulcal8311273sulcal
suldan72611043suldan
sulfa8313923sulfa_
sulfas9311563sulfas
sulpha1135403sulpha
sultan63012593sultan
sumac99514883su_mac
sumach135310113sumach
summa94713313summa_
summae103911013summae
summas104313163summas
sun37149033su_n__
sunback1548153sunback
sunbathe1344033sunbathe
sunbaths1344383sunbaths
sunbeam1146053sunbeam
sunbow1145823sunbow
sundaes8313093sundaes
sunder74019823sunder
sundew10369693sundew
sundial859863sundial
sundog837613sundog
sundry1057943sundry
sunfast1038503sunfast
sunfish1338883sunfish
sung55832173su_n_g
sunk85031813su_n_k
sunken103511783sunken
sunket103721363sunket
sunlamp1144163sunlamp
sunland837473sunland
sunlit61516103sunlit
sunnier73412153sunnier
sunnily1037833sunnily
sunning83715673sunning
sunrays1037083sunrays
suns45841903su_n_s
sunset63723633sunset
suntans72111733suntans
sunup7313053su_nup
sunups837263sunups
sunward1137653sunward
supra73614253supra_
sura45740293su_ra_
surahs94515543su_rahs
sural55931263su_ral
suras55336323su_ras
surname937603surname
surra55521343surra_
surras65919533surras
surtax1337843surtax
sutra54217933sutra_
sutras64818583sutras
sutta54015333sutta_
suttas63813793suttas
synch135011793s_ynch
syngas10368913syngas
syntax1634303syntax
synth113711823s_ynth
tuna45127843tu_na_
tunas54224123tu_nas
tunnage8166373tunnage
tunned74014493tunned
tunnel64310633tunnel
tunny86515033tunn_y
tussah9356233tussah
ulna46317323_ulna_
ulnad65611453_ulnad
ulnae55214573_ulnae
ulnar56013983_ulnar
ulnas55716533_ulnas
unai44824783_u_nai
unau43924153_u_nau
unban72114333_unban
unbar71913613_unbar
uncap9312283_uncap
unhat81119263_unhat
unjam1448723_unjam
unlash938793_unlash
unlay84613703_unlay
unman72715423_unman
unnail6410583_unnail
unsay83212843_unsay
unsnag736393_unsnag
unsnap836203_unsnap
usnea539393usnea_
usneas638333usneas

Search took 7 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 Limit1127162665.97018880.4
3Display Results2662660.0763500.0
 (SQL Overall)1786912666.18628886.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.