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

264 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
pians7512696(None) 
pains75138281pains
pans65855731p_ans
peans75437641peans
pian66136091pian_
piano76118711piano
pianos84315931pianos
pias66542551pia_s
pinas75434451pinas
pins65558451pi_ns
pions75826391pions
pirns76020091pirns
plans75731271plans
ains46158882ai_ns
airns55521032airns
alans55636172alans
apian75018332apian_
avians93711562avians
azans146516882azans
bans66555142_bans
beans75734692beans
bias64738162bia_s
bins66548252bi_ns
brans75437432brans
cains75334302cains
cans65050852_cans
cions75222852cions
clans75031012clans
cyans105714812cyans
dans56748152_dans
deans66131392deans
dials64925342dials
dins56652042di_ns
divans104612392divans
diwans105110372diwans
elans55527752elans
fans76247372_fans
fiars86720832fiars
fiats85324482fiats
fins75849092fi_ns
firns86018542firns
flans85327972flans
gains65729512gains
giant65430592giant
giants74713502giants
gins55543952gi_ns
girns64516802girns
glans65125832glans
grans64832542grans
guans64419442guans
hins76447992hi_ns
inns46920932_inns
ins35945602_i_ns
ions46737852_ions
jeans126022112jeans
jinns126013842jinns
jins115635012ji_ns
kains96125642kains
khans124615172khans
kiang104811352kiang
kiangs11378362kiangs
kilns95112982kilns
kinas95626912kinas
kins85747912ki_ns
kirns95315452kirns
koans95818622koans
leans55536252leans
liana53915892liana
lianas63713382lianas
liane54720662liane
lianes63819322lianes
liang64914412liang
liangs74410592liangs
liars54723162liars
liens56525502liens
ligans76817732ligans
limans84816302limans
limns75718392limns
linns56123332linns
lins47059052li_ns
lions55923212lions
loans56026462loans
mains75635112mains
mans66354552_mans
means75831232means
miens76118302miens
minas75434112minas
moans74624372moans
naans55815252naans
nans46139402_nans
pacs85842182p_acs
pads76742952p_ads
paeans85118262paeans
pagans95717922pagans
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
paisans93614752paisans
pals66951352p_als
pams85641762p_ams
pan58466452p_an_
pane64950292p_ane
panes76148692p_anes
pang75336302p_ang
pangs84628672p_angs
pansy105717972p_ansy
pant66061262p_ant
pants76536922p_ants
paps86443452p_aps
parians93519732parians
pars67560792p_ars
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
pavans115715592pavans
pawns108818132pawns
paws96038182p_aws
pays95940222p_ays
peags86122842peags
peaks114825622peaks
peals75235492peals
pean66147172pean_
pears75138612pears
peas65755062pea_s
peats76140192peats
pecans101515832pecans
peens76428192peens
peins76128062peins
pekans121710552pekans
pens65649642p_ens
peons75327182peons
phials1158872phials
phons105221142phons
pia56848032pia__
pial65636702pia_l
pianic103714122pianic
pianism11611032pianism
pianist9615102pianist
pibals103813082pibals
picas94626522picas
picks135226142picks
pics85633912pi_cs
piers75926332piers
pies66949602pi_es
pignus937952pignus
pigs76634222pi_gs
piing85218832piing
pikas114218092pikas
pikes115031032pikes
pikis115116392pikis
pilafs113511022pilafs
pilaus84114132pilaus
pilaws11399432pilaws
piles74742612piles
pilis75825202pilis
pills74130972pills
pilus75921062pilus
pimas94725102pimas
pimps114616982pimps
pin57066722pi_n_
pina65842632pi_na
pinang92611592pinang
pinangs10267792pinangs
pine67755712pi_ne
pines76048862pines
ping75943592pi_ng
pings85830882pings
pink107039382pi_nk
pinks115729382pinks
pinna75320182pinna
pinnas85315512pinnas
pinny105222062pinny
pinons86019942pinons
pint66963172pi_nt
pints75936222pints
piny911838352pi_ny
pion67235292pion_
pious74621272pious
pipals104213642pipals
pipes96030142pipes
pips85837132pi_ps
pirana8713262pirana
piranas9912602piranas
pirn67128372pirn_
pis56362032pi__s
pisos76021062pisos
piss65033332pi_ss
pitas77427672pitas
piths105817542piths
pitmans11188742pitmans
pitons85319042pitons
pits66348742pi_ts
pixes144323172pixes
plains85019592plains
plan65833942plan_
plane74929142plane
planes85028082planes
plank115221142plank
planks124116752planks
plant75437112plant
plants84921802plants
plats75531372plats
plays106320772plays
pliant83918822pliant
pons65850602p_ons
poons75430972poons
porns75527342porns
prams96125512prams
prang84820322prang
prangs94816232prangs
prank115019452prank
pranks124814722pranks
praos74923562praos
prats76333392prats
praus74621752praus
prawns11509022prawns
prays105022432prays
prions84317782prions
ptisans9317362ptisans
punas74826752punas
puns66641482p_uns
pyas96225702pya_s
pyins105815862pyins
pyrans11411062pyrans
rains55140232rains
rials55026672rials
riant55833152riant
rias45540592ria_s
rins46153192ri_ns
roans54926442roans
sains55639972sains
sans45153362_sans
scans74625102scans
sials54227242sials
signs65516322signs
sins46755272si_ns
spans74528732spans
speans85417142speans
spins75327982spi_ns
swans84625012swans
tains54936322tains
tans46154832_tans
tins45251302ti_ns
titans63414912titans
trans54933042trans
ulans54921302ulans
vans76236732_vans
vials85822382vials
viand9511072viand
viands1047812viands
vinas85126342vinas
wains86930872wains
wans76452272_wans
weans85326742weans
wigans104511702wigans
wins75949172wi_ns
witans93412932witans
yeans86624882yeans
yins75335122yi_ns
yuans84613322yuans
zins135735002zi_ns

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.296603685.8
2DLD Change Limit538002641.42337807.4
3Display Results2642640.0763473.7
 (SQL Overall)1786912641.79599549.3
 
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.