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

128 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
paucity143582(None) 
raucity1235851raucity
acuity1139372_acuity
caducity1643882caducity
opacity1436312opa_city
pacify1667472pa_cify
parity114719872pa_rity
paughty16294322paughty
purity114114912p_urity
saucily1237912saucily
vacuity1545762vacuity
acidy117214893_a_cidy
amity10416093_a_mity
audacity1444823_audacity
audit62527883_audit_
audits72814113_audits
augite7312613_augite
aunty85919813_au_nty
basicity1546313basicity
bauxite1635573bauxite
calcify1735873calcify
calcite11413783calcite
capacity1746023capacity
cavity14310013ca_vity
cecity1398153_cecity
city95122623___city
crucify1744063crucify
crudity1336043crudity
dacite91115883da_cite
dacoity1366183dacoity
dakoity1543423dakoity
duality1147963duality
edacity1336373edacity
equity1838103equ_ity
faculty1535573faculty
falsity1335903falsity
fancify1834983fancify
fancily1538253fancily
fatuity1336043fatuity
faucet115816553faucet_
faucets12578443faucets
faucial1257323faucial
faulty12429363fau_lty
fruity12429693fru_ity
gaseity1135113gaseity
gaudily1236523gaudily
gauzily2034393gauzily
haughty17334643haughty
jaunty16388513jau_nty
lacily11612763la_cily
laity85318903la__ity
laxity1637273la_xity
leucite937753leucite
lucite8313343_lucite
maturity1367433maturity
naughty14445623naughty
nudity1037993_nudity
opacify1743653opa_cify
outcity1238453outcity
pacey126720283pa_c_ey
pacier105018683pa_cier
pacing114522753pa_cing
packly17228333pa_ckly
pact86648723pa_c_t_
pacts95125803pa_c_ts
pacy115328683pa_c__y
painty114714753pa_inty
pandit93820753pandit_
pandits103914213pandits
panicky1833853panicky
panty105929303pa__nty
parroty1247863parroty
partita9310863partita
partite9317133partite
party106630613pa__rty
pasty105725053pa__sty
patchily1885813patchily
patchy16509573patc_hy
patty104723613pa__tty
paty95234563pa___ty
paucities1348503paucities
paulin8312983pauli_n
paulins9312613paulins
paunchy17324443paunchy
pausing103912813pausing
pawkily1934203pawkily
piosity1268643piosity
pity96031933p___ity
plaudit1046253plaudit_
plaudits1144263plaudits
pluckily1963413pluckily
plucky17406583pluc_ky
polity113015863p_olity
pouchy16538663pouc_hy
pouty107018813pou__ty
pricily142710283pricily
privity15268313privity
probity14299683probity
punily11311773p_unily
punty106021613p_u_nty
purify14399153p_urify
purty105019403p_u_rty
putty104721403p_u_tty
quality1938563quality
rabbity14266303rabbity
racily11715173ra_cily
rapacity1544983rapacity
rarity93615493ra_rity
sagacity1445243sagacity
salacity1347853salacity
sanctity1345593sanctity
sanity9316203sa_nity
saucier9810283saucier
saucing10311003saucing
saucy104615163sauc__y
scarcity1545093scarcity
sparsity1345463sparsity
suavity1336313suavity
tacit76333673ta_cit_
tacitly1236223ta_citly
unity84918493__unity
vanity12311933va_nity
varsity1356673varsity
vastity1336203vastity
vaulty12388443vau_lty
vaunty12409063vau_nty
waucht14399413waucht_
wauchts15285283wauchts

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.440406115.9
2DLD Change Limit1340271286.93619323.4
3Display Results1281280.0462782.6
 (SQL Overall)1786911287.42224075.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.