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

240 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
punkah1534709(None) 
punka114515481punka_
punkahs16284781punkahs
punkas123410671punkas
pucka133412802pucka_
pujah17478542pu_jah
pukka10457132pukka_
puna65331652pun_a_
punas74826752pun_as
punch125118422pun_ch
punish111411502punish
punk105729972punk__
punker123718822punker
punkey154011172punkey
punkie123513612punkie
punkin123611522punkin
punkish16257692punkish
punks114822682punk_s
punky144419392punk_y
purdah12288752purdah
sukkah12123732sukkah
sunnah9369352sunnah
ankh111114413_ank_h
buna64730723bun_a_
bunas75126573bun_as
bunch125118603bun_ch
bunk105731353bunk__
bunked135118373bunked
bunker124519373bunker
bunko115514513bunk_o
bunkos124210323bunkos
bunks115125083bunk_s
bunkum1435983bunkum
bunya103810093bunya_
bunyas11359433bunyas
burka114617693burka_
burkas124513803burkas
cuneal8611513cuneal
dumka12438833dumka_
dunam8313733dun_am
dunch115316263dun_ch
dunk96228573dunk__
dunked124315283dunked
dunker113616463dunker
dunks105621193dunk_s
eunuch1154363eunuch
fungal10388733fungal
funk115825623funk__
funked144214113funked
funker133915763funker
funkia1336343funkia
funkias1435383funkias
funks125318913funk_s
funky154315133funk_y
ganjah17145493ganjah
gunk95423573gunk__
gunks104517723gunk_s
gunky135514113gunk_y
gunman9299453gunman
hookah16488243hookah
hunch136416213hun_ch
hunh106323733hun__h
hunk116029543hunk__
hunker133917673hunker
hunkey164210883hunkey
hunkie133812383hunkie
hunks125321453hunk_s
hunky155417733hunk_y
huppah1644183huppah
hurrah12369183hurrah
huzzah2044423huzzah
jubbah2034353jubbah
jubhah2142803jubhah
junk155121033junk__
junked184311693junked
junker174213653junker
junket173815023junket
junkie17339603junkie
junkman2043173junkman
junks164815973junk_s
junky194513233junk_y
junta123713673junta_
juntas134210503juntas
kuna85120703kun_a_
luna46229853lun_a_
lunar57017313lun_ar
lunas55025013lun_as
lunch104917243lun_ch
lungan74710213lungan
lunk86030723lunk__
lunker104718343lunker
lunks94822453lunk_s
mullah113710733mullah
munch124917103mun_ch
mynah13569563myn_ah
nah69847003__n_ah
nullah9388143nullah
pah88853593p___ah
panda85022613panda_
pandas95521963pandas
panga85323533panga_
pangas99921103pangas
pardah123412823pardah
pariah114320583pariah
parka115120883parka_
parkas125018023parkas
paunch13369853paun_ch
pekan111613973p_ekan
penal75228373pen_al
penial84120893penial
penman10312323penman
penna74520203penna_
pennae84314033pennae
pentad9313763pentad
pickax2135913pickax
pika106322953p_ika_
pikas114218093p_ikas
pina65842633pin_a_
pinas75434453pin_as
pinch125619303pin_ch
pineal84817683pineal
pink107039383pink__
pinked134819883pinked
pinken124513283pinken
pinker125322443pinker
pinkey154314673pinkey
pinkie124414273pinkie
pinkish16279113pinkish
pinkly155012243pinkly
pinko115618253pink_o
pinkos125313873pinkos
pinks115729383pink_s
pinky145823403pink_y
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinta75727053pinta_
pintas85021393pintas
plunk114514403plunk__
plunked14429593plunked
plunker133910643plunker
plunks124711163plunk_s
plunky15377953plunk_y
polka11310413polka_
polkas1239103polkas
poundal1036403poundal
prutah1136583prutah
puck124927943puck__
pucker143817633pucker
puckish18237213puckish
pucks134322103puck_s
pugh106619233pu__gh
puja135714923pu_ja_
pujahs18404943pu_jahs
pujas145513323pu_jas
puke105025463pu_k_e
puked124716223pu_ked
pukes114523023pu_kes
pula65129373pu_la_
pulpal10408453pulpal
pulsar8329363pulsar
puma85424123pu_ma_
pumas95121563pu_mas
pun58846513pun___
punchy16398523punchy
pundit92914183pundit
pung75429633pun__g
pungle94413573pungle
pungs85422223pun_gs
punier84519223punier
punily11311773punily
punji1438203pun_ji
punjis1536693punjis
punkers133714853punkers
punkest132611693punkest
punkeys16366493punkeys
punkier133512793punkier
punkies134216803punkies
punkins133111113punkins
punned93416193punned
punner84918153punner
punnet83518843punnet
punny104217713pun_ny
puns66641483pun__s
punt65747203pun__t
punted94618713punted
punter84320023punter
punto75121323pun_to
puntos85915793puntos
punts75828003pun_ts
punty106021613pun_ty
puny95526993pun__y
pupa85422813pu_pa_
pupae96515643pu_pae
pupal97616873pu_pal
pupas95219283pu_pas
purda82914693purda_
purdahs13285483purdahs
purdas92612263purdas
push95526623pu__sh
putsch1334933putsch
runkle103611543runkle
runway12105973runway
rupiah1146213rupiah
spunk114513403spunk__
spunked14307783spunked
spunkie13215293spunkie
spunks12349333spunk_s
spunky15427163spunk_y
subah106015213su_bah
succah1336643succah
sukkahs1382703sukkahs
sunbath1236423sunbath
sundae7312873sundae
sunk85031813sunk__
sunken103511783sunken
sunket103721363sunket
sunna55016063sunna_
sunnahs10326593sunnahs
sunnas63914563sunnas
sunray9310123sunray
suntan62613003suntan
surah86823253su_rah
tanka93817483tanka_
tankas104613763tankas
tuna45127843tun_a_
tunas54224123tun_as
tussah9356233tussah
unai44824783_un_ai
unau43924153_un_au
unban72114333_unban
unbar71913613_unbar
uncap9312283_uncap
unhat81119263_unhat
unjam1448723_unjam
unlash938793_unlash
unlay84613703_unlay
unman72715423_unman
unsay83212843_unsay

Search took 6 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.1431249587.4
2DLD Change Limit1127162405.62320045.5
3Display Results2402400.0803000.0
 (SQL Overall)1786912405.84630566.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.