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

178 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
paynims143497(None) 
paynim1337361paynim_
panics103815362pa_nics
aims67738183_a__ims
amnios84912523_amnios
anils56326723_a_nils
anima74620073_a_nima
animas84418723_a_nimas
anime75423203_a_nime
animes84719593_a_nimes
animi74016663_a_nimi
animis84615943_a_nimis
animus84211613_a_nimus
anis45746463_a_ni_s
ayins85321613_ay_ins
bagnios1036073bagnios
canids95118133ca_nids
carnies94123963carnies
catnips1195893catnips
cyanids13297933cyanids
cyanins122910013cyanins
cynics13377363_cynics
danios7314603da_nios
daytime1344783daytime
daytimes1434483daytimes
denims95214323_denims
fannies103415643fannies
fanums1137263fa_nums
gayness1136843gayness
hafniums1643103hafniums
hahniums1643343hahniums
hakims1537303ha_kims
hayings14379393hayings
kainits1137763kainits
layins93817653lay_ins
magnums1234683magnums
maims96321793ma__ims
manias84029033ma_nias
manics103919933ma_nics
maxims17399673ma_xims
mayhems1763413mayhems
mayings134410513mayings
mayvins1535323mayvins
minims104514813_minims
nanism8311203na_nism
nanisms938833na_nisms
nannies73015203nannies
nims66226883___nims
pablums1345123pablums
paddies113715723paddies
padis86227143pa_di_s
padnags1135083padnags
paeanism1248703paeanism
paeanisms1347583paeanisms
paganism1369113paganism
paganisms1447933paganisms
pagings114411063pagings
paiks114719853pa__iks
pails75833063pa__ils
paining103920243paining
pains75138283pa__ins
paints85921833pain_ts
pairs75325833pa__irs
palais8420423palai_s
palings103915823palings
palliums1236703palliums
palms94921753pa__lms
palsies94420273palsies
pams85641763pa___ms
panama104213353pa_nama
panamas113112763pa_namas
pandas95521963pa_ndas
pandies104224503pandies
pandits103914213pandits
panels84716523pa_nels
panes76148693pa_n_es
pangas99921103pa_ngas
pangs84628663pa_n_gs
panic93923903pa_ni_c
panicums1444743pa_nicums
panier84425503pa_nier
paniers94717333pa_niers
panini8314273pa_nini
panino8315683pa_nino
panners93621273panners
pannes85522853pa_nnes
pannier93613353pannier
panniers10488853panniers
panning104019393panning
pans65855733pa_n__s
pansies94521983pansies
panties94230933panties
pantos85222743pa_ntos
pants76536923pa_n_ts
papains11312363papains
papism122211513pa_pism
papisms13238543papisms
pappies103214833pappies
paries84742513pa_ries
parings104219213parings
paris75145943pa_ri_s
paronyms1546553paronyms
parries93925843parries
parsnips1245533parsnips
parties93230863parties
parvis116114803parvi_s
passim10410283passim_
pasties94529813pasties
pastils94416173pastils
pastime114611973pastime
pastimes123611903pastimes
pastis84924323pasti_s
patinas96318523patinas
patines95225763patines
patins87528783pa_tins
patios85221783pa_tios
patness92912283patness
patois84319363patoi_s
patsies93919483patsies
patties93425143patties
paulins9312613paulins
pavings134011633pavings
pavins114919663pa_vins
pavis106422733pa_vi_s
pawnees12298173pawnees
pawners124311073pawners
pawning134711413pawning
pawnors12297203pawnors
pawns108818133pawn__s
paydays1634433paydays
payees114812903pay_ees
payers114621823pay_ers
paying123722163pay_ing
payoffs1843243payoffs
payolas12148973payolas
payors114312643pay_ors
payouts1247303payouts
pays95940223pay___s
penis75129323p_eni_s
pennies94218813pennies
pennis84315743penni_s
peonies93620153peonies
peonism11611103peonism
peonisms1238443peonisms
phenoms1437813phenoms
phonics143110723phonics
phonies123717513phonies
physics17265963physics
physis14359663physi_s
phytins15317893phytins
pianism11611033pianism
pianisms1249013pianisms
picnics13297343picnics
pinnies93318443pinnies
playtime1544793playtime
playtimes1644413playtimes
plenism11310113plenism
plenisms1237963plenisms
plenums1136533plenums
ponies84833463p_onies
prelims1139823prelims
prims95425933p__rims
pyins105815863p_y_ins
pyknics1842483pyknics
pyxies18338293p_yxies
pyxis17458633p_yxi_s
ranids75118703ra_nids
ranis55235833ra_ni_s
sanies63031953sa_nies
santims9312603santims
sayids104310973say_ids
sayings113610833sayings
sayyids14193833sayyids
taenias7311283taenias
tannins72813223tannins
tawnies102812503tawnies
zanies153219673za_nies
zayins18409713zay_ins

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 Limit1340271786.53020524.8
3Display Results1781780.0632825.4
 (SQL Overall)1786911786.99925530.9
 
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.