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

198 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
pyurias123670(None) 
pyuria1136951pyuria_
anurias7312242anurias
dysurias1244452dysurias
polyurias1445482polyurias
purdas92612262p_urdas
purins83722652p_urins
puris75332022p_uri_s
pyemias1436802pyemias
abulias93210693abulias
agrias74315393_agrias
amusias938573amusias
anuria6313103anuria_
aporias9315133aporias
arias55438023__arias
auras55932553_aur_as
auris55331523_auri_s
buras74736293_bur_as
burial84117623_burial
burials93612083_burials
buries84633273_buries
burins84221893_burins
burkas124513803_burkas
burqas174410903_burqas
bursas85318273_bursas
cerias83321973_cerias
curia74523763_curia_
curiae84518373_curiae
curial84019153_curial
curies84934023_curies
curios83218333_curios
cyprian1445343cyprian
cyprians1544213cyprians
dhurnas1153443dhurnas
douras75016723dour_as
dulias71212743_dulias
duras65727723_dur_as
durian7312003_durian
durians839573_durians
durras74713373_durras
dysuria1144923dysuria_
exurbias1743653exurbias
eyras84715923ey_r_as
eyries93816813ey_ries
ferias95020393_ferias
furies95126373_furies
glorias81610313glorias
houris94514563houri_s
hybrids16236013hybrids
hybris14247003hybri_s
hydras13239313hydr_as
hydria13227903hydria_
hydriae14246903hydriae
hydrids15267233hydrids
juries134120633_juries
kauries113613193kauries
kauris103611523kauri_s
kerrias11289513kerrias
kurtas10349883_kurtas
kyries133411373ky_ries
latrias71913213latrias
lauras63414333laur_as
lycras11287243lycr_as
lyrics11357943ly_rics
muras75329563_mur_as
murids93212193_murids
murras84916003_murras
myopias14308143myopias
myriad1235893my_riad
myriads1334343my_riads
myricas1436743my_ricas
norias65518183_norias
nubias8310083_nubias
nutrias739813nutrias
pagurian1144613pagurian
pagurians1243393pagurians
pagurids12144003pagurids
papricas1447053papricas
paprikas1643853paprikas
paras76143043p_ar_as
pariah114320583p_ariah
pariahs123812343p_ariahs
parian83223963p_arian
parians93519733p_arians
paries84742513p_aries
paris75145943p_ari_s
parkas125018023p_arkas
parries93925843parries
paruras9310533paruras
paulins9312613paulins
peeries93623023peeries
pelorias10410583pelorias
penuries10311663penuries
perils84121853p_erils
peris75537073p_eri_s
perries93226603perries
petunias1066013petunias
phobias14228183phobias
pias66542553p___ias
pleuras937413pleur_as
plumerias1344983plumerias
plural839823plur_al
plurals936913plurals
pluvial1245433pluvial
pluvials1343713pluvials
pluvian1245333pluvian
polyuria1355813polyuria_
pooris83916843poori_s
pourers93513673pourers
pouring103115863pouring
pours74623183pour__s
pries74339533p__ries
prigs85219703p__rigs
primas104418103p__rimas
prims95425933p__rims
priss74623893p__riss
proas75028803p__roas
prurigo1043023prurigo
prurigos1142363prurigos
pruritus1043943pruritus
pterins9812993pterins
pubis94616463p_ubi_s
pujas145513323p_u_jas
pulis74225603p_uli_s
pumas95121563p_u_mas
punas74826753p_u_nas
punkas123410673p_unkas
pupas95219283p_u_pas
pupils10389913p_upils
puranas9712643p_uranas
purda82914693p_urda_
purdah12288753p_urdah
purdahs13285483p_urdahs
purees84721683p_urees
purges94421763p_urges
puri65931443p_uri__
purify14399153p_urify
purin75527593p_uri_n
purine85321893p_urine
purines94420763p_urines
purism104715063p_urism
purisms114110833p_urisms
purist85525053p_urist
purists94014073p_urists
puritan939283p_uritan
puritans1037633p_uritans
purity114114913p_urity
purlins93415423p_urlins
purls74723353p_ur_ls
purrs75320433p_ur_rs
purs65641043p_ur__s
purses84826373p_urses
pyaemias1545063pyaemias
pyas96225703py___as
pyemia1337553pyemia_
pygmies15205673pygmies
pyins105815863py__ins
pyjamas21263523pyjamas
pyknics1842483pyknics
pyosis114012123pyosi_s
pyran10514473py_r_an
pyrans11411063py_rans
pyres105523883py_r_es
pyrexias20224993pyrexias
pyric123815073py_ri_c
pyrite11913313py_rite
pyrites12812203py_rites
pyrolas1239863pyrolas
pyros105718293py_r_os
pyrrhics1842623pyrrhics
pyrrols1235403pyrrols
pyxies18338293py_xies
pyxis17458633py_xi_s
rias45540593___rias
saurian739913saurian
saurians837763saurians
sauries72821623sauries
sharias102516003sharias
suras55336323_sur_as
surras65919533_surras
thorias102312043thorias
thulias1035743thulias
tsuris62710203tsuri_s
tzuris15286913tzuri_s
urbias839083__urbias
ureas55826013__ureas
urial54823023__urial
urials64415193__urials
usuries7510633usuries
varias95019903_varias
yautias1046333yautias
yerbas11119293_yerbas
yttrias1044513yttrias
yucas106013913_yu_cas
yuccas13426553_yuccas
yugas95012063_yu_gas
yurta86014253_yurta_
yurts87216533_yur_ts

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 Filter1786911340270.1531167915.0
2DLD Change Limit1340271986.51620568.9
3Display Results1981980.0802475.0
 (SQL Overall)1786911986.74926476.7
 
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.