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

155 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
pyins10581586(None) 
ayins85321611ayins
pains75138281pains
peins76128061peins
pins65558451p_ins
pyin96823231pyin_
yins75335121_yins
ains46158882_ains
amins75534322amins
ayin76331742ayin_
bins66548252_bins
brins75533972brins
cains75334302cains
chins105631462chins
coins75834552coins
cyans105714812cyans
dins56652042_dins
djins1368452djins
dying105316032dying
dyings11478132dyings
eying96117922eying
fins75849092_fins
foins85523382foins
gains65729512gains
gins55543952_gins
grins65427222grins
hins76447992_hins
hying126514742hying
hymns1337522hymns
ins35945602__ins
jins115635012_jins
joins125818412joins
kains96125642kains
kins85747912_kins
layins93817652layins
lins47059052_lins
loins56728422loins
lying95717452lying
lyings10488502lyings
lysins94610952lysins
mains75635112mains
opsins8411712opsins
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pans65855732p_ans
patins87528782patins
pavins114919662pavins
pawns108818132pawns
paying123722162paying
peans75437642peans
peens76428192peens
pein65834942pein_
pekins121812232pekins
penis75129322penis
pens65649642p_ens
peons75327182peons
phis95724902phi_s
phons105221142phons
phytins15317892phytins
pians75126962pians
pias66542552p_ias
pics85633912p_ics
pies66949602p_ies
pigs76634222p_igs
piing85218832piing
pin57066722p_in_
pina65842632p_ina
pinas75434452p_inas
pine67755712p_ine
pines76048862p_ines
ping75943592p_ing
pings85830882p_ings
pink107039382p_ink
pinks115729382p_inks
pint66963172p_int
pints75936222p_ints
piny911838352p_iny
pions75826392pions
pips85837132p_ips
pirns76020092pirns
pis56362032p_i_s
piss65033332p_iss
pits66348742p_its
plains85019592plains
plans75731272plans
plies74526512plies
plink115219122plink
plinks124913262plinks
plying124312082plying
poind84217912poind
poinds93511142poinds
point75338732point
points85618532points
pois66539042poi_s
pons65850602p_ons
poons75430972poons
porns75527342porns
pries74339532pries
prigs85219702prigs
prims95425932prims
prink114719672prink
prinks124315382prinks
print74837462print
prints84320102prints
prions84317782prions
priss74623892priss
prying124114802prying
psis68120342psi_s
puns66641482p_uns
purins83722652purins
pyas96225702py_as
pyes95528992py_es
pyic116915822pyi_c
pylons113011242pylons
pyrans11411062pyrans
pyres105523882pyres
pyros105718292pyros
pyxes175911402pyxes
pyxies18338292pyxies
pyxis17458632pyxis
quins144819852quins
rains55140232rains
reins56234562reins
rins46153192_rins
ruins55822032ruins
sains55639972sains
shins85131042shins
sins46755272_sins
skins94723462skins
spins75327982spins
spying123913252spying
tains54936322tains
thins85826332thins
tins45251302_tins
twins85118982twins
tyin76424002tyin_
tying96019842tying
veins84620492veins
vying125111812vying
wains86930872wains
whins114922332whins
wins75949172_wins
wynns11517472wynns
wyns105717032wy_ns
yens75832262_yens
yids85224962_yids
yin67648732_yin_
yips95226702_yips
zayins18409712zayins
zeins144715392zeins
zins135735002_zins

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538001551.62633087.3
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.99889434.9
 
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.