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

176 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
purdahs1328548(None) 
pardahs13289671pardahs
purdah12288751purdah_
purdas92612261purda_s
hurrahs13336772hurrahs
lurdans837072lurdans
pardah123412822pardah_
pariahs123812342pariahs
pujahs18404942pu_jahs
punkahs16284782punkahs
purda82914692purda__
surahs94515542sur_ahs
audads8167103au_dads
auras55932553aur_a_s
aurochs1245983aurochs
buddhas1463263buddhas
burans85019303bur_ans
buras74736293bur_a_s
burdens1039713burdens
burdies104117563burdies
burds84626063burd__s
bureaus979283bureaus
burghs12519923bur_ghs
burials93612083burials
burkas124513803burka_s
burlaps1156253burlaps
burqas174410903burqa_s
bursars94510893bursars
bursas85318273bursa_s
chuddahs18222583chuddahs
curaghs1334583curaghs
curdles103814573curdles
curds85725613curd__s
currachs1544543currachs
curraghs1442883curraghs
currans9310613currans
curtals93111623curtals
dahs88231813___dahs
dourahs11487253dour_ahs
duras65727723dur_a_s
durbars1077973durbars
durians839573durians
durras74713373durra_s
furans94515953fur_ans
gerahs1039413ger_ahs
hardass1139753hardass
horahs126313873hor_ahs
houdahs1434243houdahs
howdahs1733613howdahs
huppahs1743333huppahs
hurdies114015663hurdies
hurdles113613373hurdles
hurds95219073hurd__s
hurrah12369183hurrah_
hurrays13386153hurrays
huzzahs2143083huzzahs
jarrahs1735453jarrahs
jordans1566833jordans
jubbahs2143623jubbahs
jubhahs2242353jubhahs
judas134911883ju_da_s
jurats134213203jur_ats
keddahs1642923keddahs
khedahs1852953khedahs
kurbash1643803kurbash
kurgans12145653kurgans
kurtas10349883kurta_s
lurdan738363lurda_n
lurdane835983lurdane
lurdanes936063lurdanes
mudras94212253mudra_s
mullahs12388733mullahs
murals84016753mur_als
muras75329563mur_a_s
murders103311363murders
murras84916003murra_s
murrhas12286163murrhas
nullahs10316993nullahs
nurds65518523nurd__s
odahs95610083__odahs
pandas95521963panda_s
parades104121463parades
parados103816053parados
paraphs1439313paraphs
paras76143043par_a_s
pardons103817623pardons
pards85634333pard__s
pariah114320583pariah_
parians93519733parians
parkas125018023parka_s
parlays123910453parlays
parrals94414573parrals
partans94418283partans
paydays1634433paydays
pedals94316033p_edals
perdues103511333perdues
perdus93711273perd_us
perhaps1446123perhaps
phreaks1634543phreaks
plurals936913plur_als
portals94015563portals
poundals1145013poundals
praams10459643p_raams
prahu105013973p_r_ahu
prahus11458243p_r_ahus
prams96125513p_r_ams
praos74923563p_r_aos
prats76333393p_r_ats
praus74621753p_r_aus
prays105022433p_r_ays
proas75028803p_roa_s
prudes94215443prud_es
prudish1376563prudish
prutah1136583prutah_
puddles113613823puddles
puds75630513pu_d__s
pujah17478543pu_jah_
pujas145513323pu_ja_s
pulsars9358913pulsars
pumas95121563pu_ma_s
punas74826753pu_na_s
pundits10379293pundits
punkah15347093punkah_
punkas123410673punka_s
pupas95219283pu_pa_s
purana8712933pur_ana
puranas9712643puranas
purchase1545293purchase
purees84721683pur_ees
purfles122511843purfles
purgers104714003purgers
purges94421763pur_ges
purines94420763purines
purins83722653pur_ins
puris75332023pur__is
purisms114110833purisms
purists94014073purists
puritans1037633puritans
purlins93415423purlins
purls74723353pur__ls
purples112712823purples
purrs75320433pur__rs
purs65641043pur___s
pursers93916093pursers
purses84826373pur_ses
pursues94111373pursues
purveys15615903purveys
pyrans11411063pyr_ans
pyurias1236703pyuria_s
rupiahs1253333rupiahs
sardars83112903sardars
serdabs1035323serdabs
sirdars8228213sirdars
sirrahs10377303sirrahs
subahs114512383su_bahs
succahs1435323succahs
sukkahs1382703sukkahs
suldans8299723suldans
sundaes8313093sundaes
sunnahs10326593sunnahs
surah86823253sur_ah_
suras55336323sur_a_s
surds65624663surd__s
surpass938283surpass
surras65919533surra_s
torahs95115643tor_ahs
turbans939563turbans
turds65021693turd__s
tussahs10335113tussahs
uprears9107493uprears
uproars986453uproars
urds55922423_urd__s
ureas55826013_urea_s
urials64415193_urials
whidahs1743333whidahs
whydahs2041883whydahs

Search took 9 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271768.25016245.7
3Display Results1761760.0632793.7
 (SQL Overall)1786911768.46921099.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.