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

137 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
piosity126864(None) 
pilosity1366321pilosity
otiosity1155762otiosity
pigsty1235932pigs_ty
polity113015862p_olity
porosity1348592porosity
posit75833332p_osit_
posits85718712p_osits
priority1347442priority
probity14299682probity
prosily12611632prosily
prosit85124592prosit_
rimosity1345712rimosity
spinosity1444242spinosity
vinosity1445732vinosity
adiposity1544103adiposity
amosite9313163amosite
animosity1445253animosity
apposite12410013apposite
apriority1444743apriority
biggity1435013biggity
biotite9311033biotite
cariosity1446213cariosity
comity13312713_comity
cosily113613853_cosily
curiosity1444543curiosity
density1137583density
dignity1236453dignity
dimity12310473di_mity
diorite8314913diorite
dubiosity1542903dubiosity
falsity1335903falsity
fixity19427803fi_xity
frosty124710633fros_ty
ghosty13467213ghos_ty
gibbosity1752003gibbosity
gulosity1244443gulosity
hideosity1643313hideosity
inosite7314063inosite
iolite63221983_iolite
jocosity2044343jocosity
lanosity1146353lanosity
minority1347933minority
miosis83615163miosi_s
misty106120453mi_s_ty
morosity1347293morosity
mucosity1544983mucosity
niobite937953niobite
nodosity1254923nodosity
noisily1038403noisily
nosily93712683_nosily
obesity1275653obesity
opposite1247133opposite
parity114719873p_arity
pasty105725053p_as_ty
paucity1435823paucity
pesty106421713p_es_ty
phonily1537103phonily
picrite111911313picrite
piety105817303pi__ety
pigsney1342873pigsney
pinite8321243pi_nite
piolet83225643piolet_
piolets93513193piolets
pionic103515953pioni_c
piosities11311723piosities
piously1236833piously
pipit95224873pi_pit_
pipits104713063pi_pits
pisolite10310373pisolite
pisolith1346553pisolith
pissing103914803pissing
piste75824603pi_s_te
pistil83915073pi_stil
pithily1567033pithily
pity96031933p___ity
ploidy1237483plo_idy
plosion939113plosion
plosive1236673plosive
plotty11208853plo_tty
plumosity1642993plumosity
podite93315353p_odite
pointy114913283p_ointy
poising103617103poising
pokily15309063p_okily
policy133211513p_olicy
polite83625073p_olite
pomposity1844653pomposity
poshly1437723p_oshly
posies84431433p_osies
posing93922643p_osing
posited10511493p_osited
post67953363p_os_t_
postie84123963p_ostie
postin83521033p_ostin
posts75228783p_os_ts
posy96028423p_os__y
potty105621003p_o_tty
pouty107018813p_o_uty
preciosity1754633preciosity
prissily1346693prissily
privity15268313privity
probit103218353probit_
probits112712573probits
prodigy1435573prodigy
profit113016273profit_
profits122911243profits
prosier93817483prosier
prosing103319383prosing
prosody1336433prosody
prost75434103pros_t_
prostie91617743prostie
prosy106319253pros__y
ptosis83611823ptosi_s
purity114114913p_urity
pursily1238213pursily
pyosis114012123pyosi_s
ramosity1345893ramosity
rosily93914713_rosily
rosiny94414533_rosiny
rugosity1243733rugosity
serosity1148783serosity
sinuosity1243853sinuosity
sparsity1345463sparsity
speciosity1753253speciosity
tensity1039103tensity
tipsily1236043tipsily
torosity1147243torosity
varsity1356673varsity
venosity1446023venosity
viduity1445343viduity
villosity1543443villosity
viscosity1744113viscosity
visit8320963vi_sit_
visits9311423vi_sits
zoisite1635833zoisite
zygosity2442983zygosity

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271375.89022755.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.32928233.7
 
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.