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

286 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
purdah1228875(None) 
pardah123412821pardah
purda82914691purda_
purdahs13285481purdahs
purdas92612261purdas
hurrah12369182hurrah
lurdan738362lurdan
pardahs13289672pardahs
pariah114320582pariah
prutah1136582prutah
pujah17478542pu_jah
punkah15347092punkah
surah86823252sur_ah
audad71511393au_dad
aura45836253aur_a_
aurae54128113aur_ae
aural54428963aur_al
aurar54420253aur_ar
auras55932563aur_as
buddha1333173buddha
bura66139533bur_a_
buran75225303bur_an
buras74736303bur_as
burd75534263burd__
burden9412473burden
burdie93615023burdie
burds84626063burd_s
bureau8712523bureau
burgh115216033bur_gh
burial84117623burial
burka114617693burka_
burkas124513803burkas
burlap1098353burlap
burqa165013093burqa_
burqas174410903burqas
bursa74921523bursa_
bursae84515603bursae
bursal84414823bursal
bursar85413253bursar
bursas85318273bursas
chuddah17263253chuddah
curagh1236553curagh
curch124415413cur_ch
curd77634983curd__
curded104217163curded
curdle95514313curdle
curds85725613curd_s
curdy115916523curd_y
curia74523773curia_
curiae84518373curiae
curial84019153curial
currach1446453currach
curragh1344293curragh
curran8312023curran
curtal83914543curtal
dah78148983___dah
dourah10479813dour_ah
dura55232113dur_a_
dural64923893dur_al
duras65727733dur_as
durbar968723durbar
durian7312003durian
durra65315793durra_
durras74713373durras
furan84320013fur_an
garda7316763garda_
gardai839663gardai
gerah9315303ger_ah
gursh94512333gur_sh
horah117922053hor_ah
houdah1335173houdah
howdah1634723howdah
huppah1644183huppah
hurdle103712793hurdle
hurds95219073hurd_s
hurrahs13336773hurrahs
hurray12459913hurray
huzzah2044423huzzah
jarrah1636683jarrah
jordan1468063jordan
jubbah2034353jubbah
jubhah2142803jubhah
judas134911883ju_das
jura116024893jur_a_
jural125120483jur_al
jurat124829323jur_at
keddah1534273keddah
khedah1743643khedah
kurbash1643803kurbash
kurgan11126783kurgan
kurta95113913kurta_
kurtas10349883kurtas
lurch104814633lur_ch
lurdane835983lurdane
lurdans837073lurdans
mudra83912433mudra_
mudras94212263mudras
mullah113710733mullah
mura65633303mur_a_
mural75225113mur_al
muras75329583mur_as
murder93613783murder
murra74519083murra_
murras84916013murras
murrha11366453murrha
nudzh1835133nu_dzh
nullah9388143nullah
nurd56224343nurd__
nurds65518523nurd_s
odah87018933__odah
pah88853593p___ah
panda85022613panda_
pandas95521963pandas
para65242173par_a_
parade94720643parade
parae76335703par_ae
paraph13311263paraph
paras76143043par_as
parch125123003par_ch
pard76441323pard__
pardee93922023pardee
pardi85723953pard_i
pardie96021443pardie
pardon94618733pardon
pards85634333pard_s
pardy115523953pard_y
pariahs123812343pariahs
parian83223963parian
parish115022353parish
parka115120883parka_
parkas125018023parkas
parlay113713993parlay
parral85517533parral
partan83820563partan
payday1536613payday
pedal86022503p_edal
perch124518833per_ch
perdie94718513perdie
perdu84216273perd_u
perdue93912633perdue
perdus93711273perdus
perdy115417333perd_y
perea75026443perea_
perish114619063perish
phreak1536153phreak
plural839823plur_al
porch125918623por_ch
portal84218463portal
poundal1036403poundal
praam94815613p_raam
prahu105013973p_r_ahu
pram85733493p_r_am
prao66229023p_r_ao
prat65952043p_r_at
prau66529473p_r_au
pray96331533p_r_ay
preach133613923p_reach
proa66229963p_roa_
proas75028803p_roas
prude84615973prud_e
prudes94215443prudes
prudish1376563prudish
pruta7314243pruta_
pucka133412803pucka_
pud65836653pu_d__
puddle103914153puddle
puddly13438133puddly
pudgy124911163pu_dgy
pudic104614563pu_dic
puds75630513pu_d_s
pugh106619233pu__gh
puja135714923pu_ja_
pujahs18404943pu_jahs
pujas145513323pu_jas
pukka10457133pukka_
pula65129373pu_la_
pulpal10408453pulpal
pulsar8329363pulsar
puma85424123pu_ma_
pumas95121563pu_mas
puna65331653pu_na_
punas74826753pu_nas
punch125118423pu_nch
pundit92914183pundit
punish111411503punish
punka114515483punka_
punkahs16284783punkahs
punkas123410673punkas
pupa85422813pu_pa_
pupae96515643pu_pae
pupal97616873pu_pal
pupas95219283pu_pas
pur56840553pur___
purana8712933purana
puranas9712643puranas
pure65543333pur__e
puree74632843pur_ee
pureed95017813pureed
purees84721683purees
purely114013633purely
purer75127903pur_er
purest84021933purest
purfle112511183purfle
purge85324603pur_ge
purged104918263purged
purger94717233purger
purges94421763purges
puri65931443pur__i
purify14399153purify
purin75527593pur_in
purine85321893purine
purins83722653purins
puris75332023pur_is
purism104715063purism
purist85525053purist
puritan939283puritan
purity114114913purity
purl65631423pur__l
purled94520753purled
purlin83615863purlin
purls74723353pur_ls
purple102712683purple
purply13369053purply
purr64925813pur__r
purred94218073purred
purrs75320433pur_rs
purs65641043pur__s
purse76028893pur_se
pursed95220883pursed
purser85020473purser
purses84826373purses
pursue84512253pursue
pursy105016413pur_sy
purty105019403pur_ty
purvey14559573purvey
push95526623pu__sh
putsch1334933putsch
pyran10514473pyr_an
pyuria1136953pyuria_
pyurias1236713pyurias
qursh174110843qur_sh
qurush1835503qurush
rah68052403__r_ah
rupiah1146213rupiah
rural55821173rur_al
rurban849043rurban
sardar73013173sardar
serdab937833serdab
sirdar7269103sirdar
sirrah9379753sirrah
subah106015213su_bah
succah1336643succah
sukkah12123733sukkah
suldan72611043suldan
sundae7312873sundae
sunnah9369353sunnah
sura45740293sur_a_
surahs94515543sur_ahs
sural55931263sur_al
suras55336333sur_as
surd56433813surd__
surds65624663surd_s
surra55521343surra_
surras65919533surras
surtax1337843surtax
torah87125273tor_ah
turban8310483turban
turd56027623turd__
turds65021693turd_s
tussah9356233tussah
upreach1444693upreach
uprear8168793uprear
uproar8106933uproar
uprush1135783uprush
urban72013863_urban
urd46427043_urd__
urds55922423_urd_s
urea46528053_urea_
ureal56722683_ureal
ureas55826013_ureas
urial54823023_urial
ursa44116903_ursa_
ursae55214453_ursae
whidah1634803whidah
whydah1942953whydah
yurta86014253yurta_

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.376475242.0
2DLD Change Limit1127162864.95022770.9
3Display Results2862860.0803575.0
 (SQL Overall)1786912865.40633054.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.