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

218 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
paynim133736(None) 
paynims1434971paynims
panic93923902pa_nic
passim10410282passim
paying123722162paying
aim57858213_a__im
amnia75918643_amnia
amnic95516243_amnic
amnio75218053_amnio
ani37751183_a_ni_
anil46437433_a_nil
anima74620073_a_nima
anime75423203_a_nime
animi74016663_a_nimi
anis45746463_a_nis
ayin76331743_ay_in
ayins85321613_ayins
baalim1038473baalim
bagnio937523bagnio
bani65334963ba_ni_
baying125222583baying
canid85526343ca_nid
cannie83819363cannie
carnie84421093carnie
catnip1097973catnip
cyanic133110773cyanic
cyanid123912043cyanid
cyanin113911453cyanin
cynic124712423_cynic
danio6319783da_nio
daylit10512493daylit
daytime1344783daytime
denim85518843_denim
fanum10313443fa_num
faying134521073faying
garni6315703garni_
goyim1148603goy_im
hafnium1544243hafnium
hahnium1544433hahnium
hakim14311833ha_kim
haying134420613haying
hazanim2164623hazanim
kainit10414483kainit
kaonic1238763kaonic
layin84720333lay_in
laying104525703laying
layins93817653layins
magnum1136733magnum
maim85831493ma__im
mania75634153ma_nia
manic94629443ma_nic
maxim165216003ma_xim
mayhem1644923mayhem
maying124421153maying
mayvin1436523mayvin
minim97321603_minim
nanism8311203na_nism
nannie63713223nannie
nim57142953___nim
pablum1237503pablum
pacing114522753pacing
padi76331783pa_di_
padis86227143pa_dis
padnag1036073padnag
padri85815173padri_
paeanism1248703paeanism
paganism1369113paganism
paging104020403paging
paid75737483pa__id
paik105726803pa__ik
pail66141833pa__il
pain65647243pa__in
painch133511323painch
pained95622853pained
paining103920243paining
pains75138283pain_s
paint75443693pain_t
paints85921833paints
painty114714753painty
pair66031513pa__ir
palais8420423palais
paling93530133paling
pallia83015593pallia
pallid93915283pallid
pallium1149013pallium
palm85331363pa__lm
palpi95414553palpi_
pam77858393pa___m
pan58466453pa_n__
panama104213353pa_nama
panda85022613pa_nda
pandit93820753pandit
pandy115021173pa_ndy
pane64950293pa_n_e
paned85437183pa_ned
panel76023623pa_nel
panes76148693pa_nes
pang75336293pa_n_g
panga85323533pa_nga
pangs84628663pa_ngs
panics103815363pa_nics
panicum1346393pa_nicum
panier84425503pa_nier
panini8314273pa_nini
panino8315683pa_nino
panne76623653pa_nne
panned94123433panned
panner84224763panner
pannes85522853pannes
pannier93613353pannier
panning104019393panning
pans65855733pa_n_s
pansy105717973pa_nsy
pant66061263pa_n_t
pantie84326473pantie
panto76129413pa_nto
pants76536923pa_nts
panty105929303pa_nty
papain10313793papain
papism122211513papism
pappi84810893pappi_
papyri1334903papyri_
pardi85723953pardi_
pardie96021443pardie
paring94236493paring
paris75145943pa_ris
paronym1437503paronym
parsnip1146323parsnip
parvis116114803parvis
pastie85525523pastie
pastil85018323pastil
pastime114611973pastime
pastis84924323pastis
patin76832853pa_tin
patina86022193patina
patine85328123patine
patins87528783patins
patio74426353pa_tio
patois84319363patois
pattie84020963pattie
paulin8312983paulin
paunch13369853paunch
pavid115717003pa_vid
pavin105623203pa_vin
paving124519743paving
pavins114919663pavins
pavis106422733pa_vis
pawing124519553pawing
pawn94625303pawn__
pawned124513283pawned
pawnee113115403pawnee
pawner114212923pawner
pawning134711413pawning
pawnor11357243pawnor
pawns108818133pawn_s
pay88461183pay___
payday1536613payday
payed115925933pay_ed
payee105524723pay_ee
payees114812903payees
payer105125723pay_er
payers114621823payers
payoff1736023payoff
payola11208113payola
payor105413843pay_or
payors114312643payors
payout11714653payout
pays95940223pay__s
penis75129323p_enis
penni74617903penni_
pennia84412973pennia
pennis84315743pennis
peonism11611103peonism
pernio8513143pernio
phenix1837133phenix
phenom1339473phenom
phonic133315213phonic
phylic16279553phylic
phylum1655153phylum
physic16288473physic
physis14359663physis
phytin14459013phytin
pianic103714123pianic
pianism11611033pianism
picnic123410263picnic
pinyin112710613pinyin
pionic103515953pionic
playing133816093playing
playtime1544793playtime
plenism11310113plenism
plenum1039503plenum
plying124312083plying
praying133717323praying
prelim10311423prelim
prim85132203p__rim
prying124114803prying
pyic116915823p_y_ic
pyin96823233p_y_in
pyins105815863p_yins
pyknic1734893pyknic
pyoid11513763p_yoid
pyric123815073p_yric
pyxie17359363p_yxie
pyxis17458633p_yxis
rani46640113ra_ni_
ranid66429333ra_nid
ranis55235833ra_nis
raying105027193raying
sayid95516723say_id
saying104325543saying
sayyid13185353sayyid
spaying133014623spaying
taenia6313193taenia
tannic82811473tannic
tannin62613923tannin
ulpanim1143993ulpa_nim
zayin174512043zay_in
zayins18409713zayins

Search took 7 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 Filter1786911127160.373479064.3
2DLD Change Limit1127162185.73619650.6
3Display Results2182180.0762868.4
 (SQL Overall)1786912186.18528891.0
 
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.