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

183 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
pawns10881813(None) 
awns75324431_awns
dawns95916591dawns
fawns115914261fawns
lawns85215421lawns
pains75138281pains
pans65855731pa_ns
pawls105617661pawls
pawn94625301pawn_
paws96038181paw_s
prawns11509021prawns
spawns11577921spawns
yawns114213271yawns
ains46158882_ains
awes76037552_awes
awls75926092_awls
awn68035912_awn_
awny105919302_awny
banns75321232banns
bans66555142ba_ns
barns76335142barns
bawds116115492bawds
bawls105719322bawls
brawns115614082brawns
cains75334302cains
cans65050852ca_ns
carns75937562carns
caws96036112caw_s
damns84916922damns
dans56748152da_ns
darns66927892darns
dawks135213492dawks
dawn85624202dawn_
daws86638242daw_s
dawts97216122dawts
downs94918572downs
earns55927562earns
fans76247372fa_ns
fauns84516752fauns
fawn105321952fawn_
fawny144711712fawny
gains65729512gains
gawks136811632gawks
gawps115911012gawps
gowns95115102gowns
hawks155415702hawks
haws106439442haw_s
impawns1433322impawns
jawans1657842jawans
jaws145027292jaw_s
kains96125642kains
kaons95014852kaons
karns96624142karns
lawn75925632lawn_
lawny115912012lawny
laws76441682law_s
mains75635112mains
mans66354552ma_ns
mawn94424142mawn_
maws96437142maw_s
naans55815252naans
nans46139402na_ns
owns76819582_owns
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
pads76742952pa_ds
paeans85118262paeans
paeons83915522paeons
pagans95717922pagans
pages85235072pages
paiks114719852paiks
pails75833062pails
pain65647242pain_
paint75443692paint
paints85921832paints
pairs75325832pairs
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
pan58466452pa_n_
pane64950292pa_ne
panes76148692panes
pang75336292pa_ng
pangs84628662pangs
panne76623652panne
pannes85522852pannes
pansy105717972pa_nsy
pant66061262pa_nt
pants76536922pants
papas94927492papas
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pasts75936502pasts
patens84820862patens
pates76047892pates
paths105521382paths
patins87528782patins
pats66460852pa_ts
pavans115715592pavans
paves104833922paves
pavins114919662pavins
pavis106422732pavis
paw87651172paw__
pawed115725612pawed
pawer104422972pawer
pawers114818782pawers
pawing124519552pawing
pawky173810152pawky
pawl95123262paw_l
pawned124513282pawned
pawnee113115402pawnee
pawnees12298172pawnees
pawner114212922pawner
pawners124311072pawners
pawnor11357242pawnor
pawnors12297202pawnors
paxes144928422paxes
pays95940222pa_ys
peans75437642peans
peens76428192peens
peins76128062peins
pens65649642p_ens
peons75327182peons
pews95731532pew_s
phons105221142phons
pians75126962pians
pins65558452p_ins
pions75826392pions
pirns76020092pirns
plains85019592plains
plans75731272plans
pons65850602p_ons
poons75430972poons
porns75527342porns
pows95537662pow_s
prawn105312432prawn_
puns66641482p_uns
pyins105815862pyins
rains55140232rains
rawins95617622rawins
raws75238212raw_s
sains55639972sains
sans45153362sa_ns
sawn75428162sawn_
saws75839482saw_s
spans74528732spa_ns
spawn107811712spawn_
swans84625012swans
tains54936322tains
tans46154822ta_ns
tarns56433952tarns
tawny114713652tawny
taws75641592taw_s
towns86018882towns
vans76236732va_ns
vaws105527322vaw_s
wains86930872wains
wans76452272wa_ns
warns87231002warns
wawls115416472wawls
waws106834902waw_s
yarns85621792yarns
yawls114613602yawls
yawn106219092yawn_
yawps13628792yawps
yaws105531212yaw_s

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 Limit538001831.44037361.1
3Display Results1831830.0463978.3
 (SQL Overall)1786911831.782100275.5
 
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.