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

348 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
puranas971264(None) 
piranas9912601piranas
purana8712931purana_
burans85019302buran_s
curaras93911942curaras
furanes103214862furanes
furans94515952furan_s
guaranas995932guaranas
jurants14379212jurants
ourangs8318502ourangs
parangs104314372parangs
pirana8713262pirana_
piranhas13135872piranhas
pirayas1277482pirayas
prajnas1635452p_rajnas
prangs94816232p_rangs
pranks124814722p_ranks
punas74826752pu__nas
puranic11410482puranic
purdas92612262pur_das
purines94420762purines
purins83722652purin_s
pyrans11411062pyran_s
ruanas6311262ru_anas
uranias72113812_uranias
anas46649863___anas
anurans73810553anuran_s
arenas65021993_arenas
asanas6514113_asanas
asramas938303asramas
auras55932553aur__as
auroras7311703auroras
bananas93312223bananas
boranes93720403boranes
brands95118943_brands
branks124817383_branks
brans75437433_bran_s
brants85723053_brants
bravas114913323_bravas
brazas175812433_brazas
bunas75126573bu__nas
buran75225303buran__
buras74736293bur__as
burins84221893burin_s
burkas124513803bur_kas
burns74926773bur_n_s
burqas174410903bur_qas
bursas85318273bur_sas
butanes9312743butanes
bwanas1157443_bwanas
cabanas112413033cabanas
carinas93622383carinas
coronas93916903coronas
courants10310803courants
cranes84330753_cranes
cranks125015313_cranks
curacao1146293curacao
curacaos1244923curacaos
curacoas1246033curacoas
curaghs1334583curaghs
curara83712203curara_
curares94916853curares
curaris94114773curaris
curates95323823curates
curns74924273cur_n_s
currans9310613curran_s
currants1037933currants
dharnas1155373dharnas
dhurnas1153443dhur_nas
dramas95814653_dramas
duennas834143duennas
durance1059113durance
durances1158683durances
duras65727723dur__as
durians839573durian_s
durns64819863dur_n_s
durras74713373dur_ras
errands847583errands
errants7410623errants
erratas736843erratas
farinas103215233farinas
fracas11311993_fracas
francs114112193_francs
franks134912733_franks
furan84320013furan__
furane94015493furan_e
furanose1144753furanose
gramas94317203_gramas
grana65722093_grana_
grands84218243_grands
grans64832543_gran_s
grants73722473_grants
guanase836213gu_anase
guanay1037913gu_anay
guanays1134953gu_anays
guanos73811993gu_anos
guans64419443gu_an_s
guarana886303guarana_
guaranis996863guaranis
guavas1037153gu_avas
harianas1139163harianas
humans112312433human_s
iguanas835373iguanas
jacanas1638263jacanas
jarinas143712183jarinas
jnanas13207303_jnanas
jurant134216553juran_t
jurats134213203jura_ts
kanas95326913__kanas
korunas1135443korunas
kurgans12145653kurgan_s
kurtas10349883kur_tas
lianas63713383_lianas
lorans65117603loran_s
lunas55025013lu__nas
lupanar963283lupanar
lupanars1042303lupanars
lurdanes936063lurdanes
lurdans837073lurdan_s
mananas93414733mananas
manas76240423__manas
maracas11313773maracas
marantas10310023marantas
marinas93519373marinas
murals84016753mura_ls
muras75329563mur__as
murines93718223murines
murras84916003mur_ras
murrhas12286163murrhas
mutants938583mutants
naganas847983naganas
nanas55928633__nanas
nirvanas1142513nirvanas
operands1146813operands
operants1039483operants
orangs74116033_orangs
ourang73311063ouran_g
ouraris73512933ouraris
outranks12298823outranks
pacas96029403p__acas
paeans85118263paean_s
pagans95717923pagan_s
paisanas10288873paisanas
pajamas18278153pajamas
palapas11311493palapas
panadas103312213panadas
panamas113112753panamas
pandas95521963p__andas
panes76148693p__anes
pangas99921103p__angas
pangs84628663p__angs
pans65855723p__an_s
pants76536923p__ants
papas94927493p__apas
papayas1437273papayas
parades104121463parades
parados103816053parados
paramos113213513paramos
parang93715513paran_g
paranoeas1147513paranoeas
paranoias11410443paranoias
paraphs1439313paraphs
paras76143043p__aras
parents93418123parents
parians93519733parian_s
parings104219213parings
parkas125018023par_kas
partans94418283partan_s
paruras9310533paruras
patacas11311003patacas
patinas96318523patinas
pavanes123612653pavanes
pavans115715593pavan_s
peans75437643p_ean_s
pecans101515833pecan_s
pedants10310113pedants
pekans121710553pekan_s
penangs10268373penangs
personas102511873personas
phrasal1246163phrasal
phrases12711463phrases
pianos84315933p_ianos
pians75126963p_ian_s
picaras11311273picaras
pinangs10267793pinangs
pinas75434453p__inas
pinatas93711483pinatas
pinnas85315513p_innas
piraguas1144453piraguas
piranha12126363piranha
pirates93020323pirates
piraya1167713piraya_
pirns76020093pir_n_s
pitayas1286263pitayas
planar84212713p_lanar
planes85028083p_lanes
planks124116753p_lanks
plans75731273p_lan_s
plants84921803p_lants
playas114612283p_layas
plazas17409913p_lazas
plurals936913plura_ls
pornos85015253por_nos
porns75527343por_n_s
posadas1037193posadas
praam94815613p_ra_am
praams10459643p_raams
prahus11458243p_rahus
prajna1535073p_rajna_
prams96125513p_ra_ms
prance104318573p_rance
prances113618773p_rances
prang84820323p_ran_g
prank115019453p_ran_k
praos74923563p_ra_os
prases84429023p_rases
prates84633163p_rates
prats76333393p_ra_ts
praus74621753p_ra_us
prawns11509023p_rawns
praxes156215183p_raxes
praxis154012253p_raxis
prays105022433p_ra_ys
preanal9310713preanal
primas104418103p_rimas
prinks124315383p_rinks
prints84320103p_rints
proas75028803p_r_oas
prongs94314483p_rongs
prunes83419063p_runes
prunus8399363p_runus
puisnes937423puisnes
pujahs18404943puja_hs
pujas145513323pu__jas
pulings103511323pulings
pumas95121563pu__mas
puna65331653pu__na_
pungs85422223pu__ngs
punkas123410673pu_nkas
punks114822683pu__nks
puns66641483pu__n_s
punts75828003pu__nts
pupas95219283pu__pas
pupates113311433pupates
purchase1545293purchase
purda82914693pur_da_
purdah12288753pur_dah
purdahs13285483purdahs
purees84721683pur_ees
pureness101110183pureness
purfles122511843purfles
purgers104714003purgers
purges94421763pur_ges
purgings12347293purgings
purin75527593purin__
purine85321893purin_e
puris75332023pur__is
purisms114110833purisms
purists94014073purists
puritan939283puritan
puritans1037633puritans
purlines103514053purlines
purlings113910283purlings
purlins93415423purlins
purls74723353pur__ls
purples112712823purples
purpuras12105073purpuras
purrs75320433pur__rs
purs65641043pur___s
pursers93916093pursers
purses84826373pur_ses
purslanes1145523purslanes
pursues94111373pursues
purveys15615903purveys
putons83515153puton_s
pyjamas21263523pyjamas
pyran10514473pyran__
pyranose1344923pyranose
pyrenes123511223pyrenes
pyrolas1239863pyrolas
pyrones123113303pyrones
pyurias1236703pyur_ias
quants153614143qu_ants
queans153110753quean_s
ragas65326063__ragas
raias54631123__raias
rajas127317723__rajas
rands65930453__rands
ranis55235833__ranis
ranks95225733__ranks
rants55935343__rants
rayas85922053__rayas
ruana5312423ru_ana_
sarans64224433saran_s
sardanas937813sardanas
spiraeas10286233spiraeas
spirants1088283spirants
sprangs104610053sprangs
spurns84811383spur_n_s
strands83711953strands
stratas73013573stratas
sultanas8237153sultanas
sunnas63914563su_nnas
surahs94515543sura_hs
suras55336323sur__as
surras65919533sur_ras
taramas9612693taramas
tarantas839193tarantas
tartanas8258893tartanas
tranks104017763_tranks
tranqs155210313_tranqs
trans54933043_tran_s
tronas63816893_tronas
truants738153truants
tunas54224123tu__nas
turacos938623turacos
turbans939563turban_s
turns55623233tur_n_s
tyrants1037453tyrants
ulamas8910453_ulamas
ulans54921303_ulan_s
ulnas55716533_u_lnas
uplands1036943uplands
uprates93814863uprates
uraeus638793_uraeus
urania62516123_urania
uranic82315183_uranic
uranism91112513_uranism
uranous7310723_uranous
uranyl936293_uranyl
uranyls1034453_uranyls
urares64519093_urares
uraris63817273_uraris
urases63723563_urases
urates65027763_urates
urbias839083_urbias
ureas55826013_ur_eas
urinal6614123_urinal
urinals7610253_urinals
urines64724123_urines
urns46323893_ur_n_s
varnas94212823var_nas
verandas1246233verandas
wrangs104611913_wrangs
yuans84613323yu_an_s
yulans958673yulan_s
zananas16319563zananas
zenanas16286233zenanas

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 Limit1340273487.86017051.8
3Display Results3483480.1232829.3
 (SQL Overall)1786913488.13921954.9
 
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.