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

290 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
pechans1481050(None) 
pecans101515831pec_ans
pechan13511541pechan_
brechans1547412brechans
lochans1248832lochans
pachas135017142pacha_s
peahens12307572peahens
peans75437642pe__ans
pecan91919032pec_an_
peccant13311732peccant
peching154513902peching
pechs125516202pech__s
pectens11189202pectens
pectins112315232pectins
pekans121710552pe_kans
penchant1549582penchant
penchants1646202penchants
perhaps1446122perhaps
zechins21137122zechins
afghans1443573afghans
archons12311583archons
ashcans1235183ashcans
barchans1588683barchans
beans75734693be__ans
becaps123811403bec_aps
bechalk1845803bechalk
bechalks1944793bechalks
bechance1747743bechance
bechances1847613bechances
becharm1636843becharm
becharms1745343becharms
beckons15279143beckons
bedpans1237173bedpans
bemeans1148743bemeans
bemoans1138253bemoans
bethank1666273bethank
bethanks1765313bethanks
brechams1745773brechams
brechan1437223brechan_
cans65050853__c_ans
chads116122233__chads
chains114819703__chains
chais107530313__chais
chams126028503__chams
chang115418563__chang
changs125215373__changs
chant105932693__chant
chants115020393__chants
chaos105622863__chaos
chaps125326063__chaps
chars105936643__chars
chats105730093__chats
chaws135022463__chaws
chays135319743__chays
chins105631463__chins
clachans1546413clachans
clans75031013__clans
cochins141413103cochins
cyans105714813__cyans
dachas124113253dacha_s
deans66131393de__ans
decafs124010883dec_afs
decals93717713dec_als
decane93818873dec_ane
decanes103118913dec_anes
decant93524223dec_ant
decants103514443dec_ants
decays124612913dec_ays
decerns10119053decerns
deckhand1943103deckhand
deckhands2043083deckhands
declass1038733declass
declaws1336253declaws
dedans85915073de_dans
deewans11306903deewans
demeans1039723demeans
desmans1039003desmans
dewans105215143de_wans
echard1249223_echard
echards1337963_echards
eches106322163_ech_es
eching126315563_eching
echini114710433_echini
echinus1236203_echinus
echoes114715523_echoes
echos105216463_ech_os
eclats8313033_eclats
elans55527753_e_lans
enchains1348523enchains
enchant12313123enchant
enchants1347833enchants
ephahs1435503_ephahs
ephas10311543_epha_s
eschars1237183eschars
etchant1249823etchant
etchants1346023etchants
ethane94613243_ethane
ethanes103713513_ethanes
fecials123510333fecials
germans1079473germans
heehaws1643343heehaws
hetmans12187593hetmans
ipecacs1354503ipec_acs
jeans126022113je__ans
jehads1735833je_hads
khans124615173__khans
kuchens1634713kuchens
leans55536253le__ans
lechers123313963lechers
leches115421313lech_es
leching134613653leching
lechwes1535063lechwes
lectins92515003lectins
lemans85316393le_mans
lethals1038113lethals
lichens123510683lichens
lochan1139093lochan_
means75831233me__ans
meccas1239493mecca_s
mechanic1747613mechanic
mechanics1845983mechanics
mechanism1846563mechanism
mechanist1648743mechanist
medians103214213medians
merchant1548823merchant
merchants1646223merchants
messans92710463messans
methane123211793methane
methanes133812163methanes
mochas13310663mocha_s
nachas114914193nacha_s
nectars938463nectars
nuchals12216933nuchals
oceans81211003_oceans
octans81411143_octans
orphans1237773orphans
pacas96029403pac_a_s
pacha126518063pacha__
paeans85118263p_aeans
paesans93312693paesans
pagans95717923p_agans
paisans93614753paisans
pans65855733p___ans
paphians1545593paphians
parians93519733parians
partans94418283partans
paschals1566473paschals
pashas115117063pasha_s
pavans115715593p_avans
peachers153213843peachers
peaches144120053peach_es
peaching163613643peaching
peacoats1247833peacoats
peags86122843pe__ags
peahen113410133peahen_
peaks114825623pe__aks
peals75235493pe__als
pean66147173pe__an_
pears75138613pe__ars
peas65755063pe__a_s
peasant9314923peasant
peasants1038263peasants
peats76140193pe__ats
peccancy1643953peccancy
peccary1636283peccary
peccavi1643093peccavi
peccavis1743133peccavis
pech116125453pech___
peched144915343pech_ed
peckers153312673peckers
pecking164017783pecking
pecks135724433pec__ks
pecs84634103pec___s
pectase112410363pectase
pectases122411193pectases
pectate112214693pectate
pectates122213953pectates
pecten102711103pecten_
pectin102615533pectin_
pectines121914683pectines
pedals94316033pe_dals
pedant9319493pe_dant
pedants10310113pe_dants
pedlars103210213pedlars
peens76428193pe__ens
pehs95625763pe_h__s
peins76128063pe__ins
pekan111613973pe_kan_
pekins121812233pe_kins
pelicans1238093pelicans
pemicans1447043pemicans
penang92511113pe_nang
penangs10268373pe_nangs
pendant10314853pendant
pendants1139093pendants
penman10312323penman_
pennant9312493pennant
pennants1037063pennants
pennons939713pennons
pens65649643pe___ns
pentads1039523pentads
pentane9415743pentane
pentanes10316083pentanes
peons75327183pe__ons
pepsins11310433pepsins
perchance1866393perchance
perchers153611523perchers
perches143717953perch_es
perching163711633perching
pereons92815003pereons
perrons93115483perrons
persons93717013persons
pertains102113423pertains
petals84719813pe_tals
petnaps1145033petnaps
petsais938433petsais
phons105221143p__hons
pians75126963p__ians
picas94626523pic_a_s
pitmans11188743pitmans
plans75731273p__lans
platans93413123platans
pochard1537363pochard
pochards1646853pochards
precleans1344893precleans
preplans1249613preplans
prolans9314273prolans
pschent1437413pschent
pschents1544113pschents
pshaws14435703p_shaws
ptisans9317363ptisans
pyrans11411063p_yrans
pythons1537363pythons
recane83022873rec_ane
recanes93222263rec_anes
recant83228683rec_ant
recants93217093rec_ants
recaps103615733rec_aps
rechange1458183rechange
rechanges1568183rechanges
rechart12314333rechart
recharts1337663recharts
recheats1339193recheats
rechews1537293rechews
reckons13269653reckons
reclads1049993reclads
recleans1037513recleans
recoals94214623recoals
recoats92616643recoats
recoins94019243recoins
recons84922993rec_ons
redans75421023re_dans
rehabs1139023re_habs
rehang1039823re_hang
rehangs1137563re_hangs
reloans7313133reloans
remans84823003re_mans
replans92814943replans
richens12349733richens
scans74625103_sc_ans
schavs1436493_schavs
seawans10379943seawans
secant84023293sec_ant
secants93413893sec_ants
secerns987733secerns
secpars1138413secpars
sedans74816093se_dans
seitans73312303seitans
sewans95215903se_wans
sextans14349273sextans
speans85417143spe__ans
specials1238033specials
spleuchans1751593spleuchans
techies12513603techies
techno1135953tech_no
technos1236183technos
techs106915833tech__s
teopans939203teopans
tuchuns1233983tuchuns
unchains1338303unchains
urchins1238863urchins
urethans1145243urethans
vegans103910853ve_gans
weans85326743we__ans
wechts1446253wech_ts
wiccans1434603wiccans
yeans86624883ye__ans
yechs136112583yech__s
zecchins2443533zecchins
zechin20137703zechin_

Search took 8 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.406440125.6
2DLD Change Limit1340272906.64020184.8
3Display Results2902900.1102636.4
 (SQL Overall)1786912907.15624970.8
 
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.