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

271 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
peins7612806(None) 
pains75138281pains
peans75437641peans
peens76428191peens
pein65834941pein_
pekins121812231pekins
penis75129321penis
pens65649641pe_ns
peons75327181peons
pins65558451p_ins
pyins105815861pyins
reins56234561reins
veins84620491veins
zeins144715391zeins
aeons57624652aeons
ains46158882_ains
amins75534312amins
ayins85321612ayins
beans75734692beans
begins94415302begins
being84920502being
beings94613032beings
bens65945702be_ns
bins66548242_bins
brins75533972brins
cains75334302cains
ceils75019402ceils
chins105631462chins
coins75834552coins
deans66131392deans
deigns8389982deigns
deils65722862deils
dens55945072de_ns
dins56652042_dins
djins1368452djins
ens37245922_e_ns
eons46638712_eons
epics95014282epics
erns45428222_erns
feigns10407752feigns
feint84732252feint
feints94813872feints
fens76139762fe_ns
ferns85220082ferns
fins75849092_fins
foins85523382foins
gains65729512gains
gens55740072ge_ns
gins55543952_gins
grins65427222grins
heils85222192heils
heirs85618562heirs
hemins113417562hemins
hens75642572he_ns
herns84825582herns
hins76447992_hins
ins35945602__ins
jeans126022112jeans
jins115635012_jins
joins125818412joins
kains96125642kains
keens95721182keens
keirs95313672keirs
kens85435232ke_ns
kerns94719562kerns
kins85747902_kins
leans55536252leans
leis45739602lei_s
lenis56326862lenis
lens46146492le_ns
levins94514652levins
liens56525502liens
lins47059052_lins
loins56728422loins
mains75635092mains
means75831222means
meiny104015402meiny
miens76118302miens
neifs85613042neifs
neons55818682neons
oleins6313522oleins
opens76118552ope_ns
opsins8411712opsins
paeans85118262paeans
paeons83915522paeons
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pans65855722p_ans
patins87528782patins
pavins114919662pavins
pawns108818132pawns
peags86122842peags
peaks114825622peaks
peals75235492peals
pean66147172pean_
pears75138612pears
peas65755062pe_as
peats76140192peats
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pectins112315232pectins
pedes85327282pedes
peds75835242pe_ds
peeing94618082peeing
peeks115021112peeks
peels75226422peels
peen65938082peen_
peeps95822362peeps
peers75130272peers
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
peined94918842peined
peise75825772peise
peises84125042peises
pekans121710552pekans
pekes114623562pekes
pekin111514422pekin_
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pen56558842pe_n_
pend75934532pe_nd
pends85527192pends
penes75839222penes
penna74520202penna
penne75423852penne
penni74617902penni
pennis84315742pennis
penny105119452penny
pent66559072pe_nt
peon65635242peon_
peones83821042peones
peony105717562peony
pepino10310332pepino
pepinos1137692pepinos
pepos96620082pepos
peps85134512pe_ps
pepsins11310432pepsins
peres76246642peres
perils84121852perils
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
pets66248332pe_ts
pewits112810682pewits
pews95731532pe_ws
phis95724902phi_s
phons105221142phons
pians75126962pians
pias66542552p_ias
pics85633912p_ics
pieing93917652pieing
piers75926332piers
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
pleons84213342pleons
plies74526512plies
plink115219122plink
plinks124913262plinks
poind84217912poind
poinds93511142poinds
point75338732point
points85618532points
pois66539042poi_s
pons65850602p_ons
poons75430972poons
porns75527342porns
preens85020112preens
pries74339532pries
prigs85219702prigs
prims95425932prims
prink114719672prink
prinks124315382prinks
print74837462print
prints84320102prints
prions84317782prions
priss74623892priss
psis68120342psi_s
pterins9812992pterins
puns66641482p_uns
purins83722652purins
pyin96823232pyin_
quins144819852quins
rains55140232rains
reifs84819092reifs
reigns74811752reigns
rein46040892rein_
reink95518092reink
reinks105012152reinks
reis45343232rei_s
renins64526452renins
repins84924312repins
resins64528772resins
rewins95020822rewins
rins46153192_rins
ruins55822032ruins
sains55639972sains
seifs85019332seifs
seine55732872seine
seines65029902seines
seis45542392sei_s
serins64029672serins
shins85131042shins
sins46755272_sins
skeins103911902skeins
skins94723462skins
speans85417142speans
speils84116222speils
speirs85013232speirs
speiss84311642speiss
spins75327982spins
steins64818342steins
tains54936322tains
teens56227482teens
teind6213612teind
teinds738262teinds
tens45647412te_ns
terns55226872terns
theins95015422theins
thins85826322thins
tins45251302_tins
twins85118982twins
veils84918802veils
vein75625752vein_
veiny115414362veiny
venins93816702venins
wains86930862wains
weans85326742weans
weens85224052weens
weirs84316492weirs
wens76337932we_ns
whins114922332whins
wins75949172_wins
yeans86624882yeans
yens75832262ye_ns
yins75335122_yins
zein135620602zein_
zins135735002_zins

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 Filter178691538000.0961861364.6
2DLD Change Limit538002711.37339184.3
3Display Results2712710.0803387.5
 (SQL Overall)1786912711.549115358.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.