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 “pyin” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

160 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
pyin9682323(None) 
ayin76331741ayin
pain65647241pain
pein65834941pein
pin57066721p_in
pyic116915821pyic
pyins105815861pyins
tyin76424001tyin
yin67648731_yin
agin56132712agin
ain37579092_ain
akin86328032akin
amin66042252amin
ayins85321612ayins
bin56658642_bin
blin67228172blin
brin67038192brin
cain65643912cain
chin96934742chin
coin66645352coin
cyan96419622cyan
din46459462_din
djin12911632djin
dying105316032dying
eyen76223662eyen
eying96117922eying
fain75840562fain
fin66458032_fin
foin77231562foin
gain56042162gain
gin46055752_gin
grin55733722grin
hin67559562_hin
hying126514742hying
hymn12311312hymn
in28150862__in
jin106443932_jin
join116724832join
kain85334292kain
kin76353962_kin
lain46146282lain
layin84720332layin
lin37967372_lin
loin46838722loin
lying95717452lying
lysin84512782lysin
main65345512main
opsin7613472opsin
paid75737482paid
paik105726802paik
pail66141832pail
pains75138282pains
paint75443692paint
pair66031512pair
pan58466442p_an
patin76832852patin
pavin105623202pavin
pawn94625302pawn
paying123722162paying
pean66147172pean
peen65938082peen
peins76128062peins
pekin111514422pekin
pen56558842p_en
peon65635242peon
phi86524202phi_
phis95724902phis
phiz186718842phiz
phon95925382phon
phytin14459002phytin
pi48145362p_i_
pia56848032p_ia
pian66136092pian
pic76046822p_ic
pie55457402p_ie
pig65744972p_ig
piing85218832piing
pina65842632p_ina
pine67755712p_ine
ping75943592p_ing
pink107039382p_ink
pins65558452p_ins
pint66963172p_int
piny911838352p_iny
pinyin112710612pinyin
pion67235292pion
pip78051042p_ip
pirn67128372pirn
pis56362032p_is
pit56471922p_it
piu56639542p_iu
pix126437932p_ix
plain74823302plain
plan65833942plan
plie65127392plie
plink115219122plink
plying124312082plying
poi57244662poi_
poind84217912poind
point75338732point
pois66539042pois
poon67341262poon
porn65636022porn
prig75924872prig
prim85132202prim
prink114719672prink
print74837462print
prion75119992prion
prying124114802prying
psi56621622psi_
psis68120342psis
pun58846512p_un
purin75527592purin
pya87023752py_a
pyas96225702pyas
pye86432502py_e
pyes95528992pyes
pylon103614002pylon
pyoid11513752pyoid
pyran10514472pyran
pyre94925552pyre
pyric123815072pyric
pyro96019392pyro
pyx157817012py_x
pyxie17359362pyxie
pyxis17458632pyxis
quin135823922quin
rain46251732rain
rein46040892rein
rin36663182_rin
ruin47430512ruin
sain45551292sain
shin75634302shin
sin36265892_sin
skin85927522skin
spin66231302spin
spying123913252spying
syn67024122sy_n
tain45548072tain
thin76732382thin
tin36362172_tin
twin76023082twin
tying96019832tying
tyiyn11635332tyiyn
vain75233002vain
vein75625752vein
vying125111812vying
wain75840192wain
whin105225692whin
win66456292_win
wyn95921442wy_n
wynn105811292wynn
yen66847382_yen
yid76640822_yid
yins75335122_yins
yip87241172_yip
yon67348952_yon
zayin174512042zayin
zein135620602zein
zin125643772_zin

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298721600.95331345.2
3Display Results1601600.0463478.3
 (SQL Overall)1786911601.079165608.0
 
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.