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

110 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
aridities1091163(None) 
acidities12810181acidities
acridities1348291acridities
avidities13107611avidities
abilities11714142abilities
acidifies15126452acidifies
agilities10810972agilities
algidities1245952algidities
aminities11312912aminities
anilities9516002anilities
crudities1247742crudities
privities14312042privities
rabidities1347702rabidities
rapidities1347482rapidities
sapidities1348012sapidities
trinities9313342trinities
validities1447302validities
vapidities1646382vapidities
viridities14106902viridities
acidified16104983acidified
acidifier15124383acidifier
acidifiers16113223acidifiers
acridines1247723acridi_nes
activities1548903activities
acuities10312453a_cuities
additives1444443a_dditives
affinities1645713affinities
airdates939723airdat_es
amenities11310433amenities
amidines113010853amidi_nes
amities9317383a__mities
analities9715873analities
annuities947463annuities
apriorities1345403apriorities
arabilities13413103arabilities
arenites8917103arenit_es
aridity11510113aridit__y
ariettes8411353ari_ettes
assiduities1282983assiduities
atrocities1248593atrocities
auditees946463a_uditees
auditives1345723a_uditives
auralities10410223auralities
axialities1747733axialities
basicities1446863basicities
bifidities1644453bifidities
brevities1446423brevities
caninities12410493caninities
carditis11310233car_diti_s
carditises1346973car_ditises
cariosities1346473cariosities
crinites10612763crinit_es
crudites1137763crudit_es
cupidities1545973cupidities
dimities11314003_dimities
facilities1549823facilities
fervidities1863943fervidities
fetidities1447873fetidities
fixities1838213_fixities
floridities1544593floridities
fluidities1445223fluidities
frigidities1644023frigidities
gelidities1247203gelidities
gravidities1644133gravidities
gravities1338303gravities
heredities1447223heredities
humidities1645893humidities
hybridities2053513hybridities
labilities12712233labilities
lapidifies1643543lapidifies
latinities10410163latinities
lividities1445583lividities
lucidities1346253lucidities
morbidities1644613morbidities
mucidities1546233mucidities
nativities1348433nativities
nidifies1238233_nidifies
nudities939683_nudities
oddities1046603_oddities
oralities91214123oralities
parities10522973par__ities
placidities1665103placidities
primitives1745623primitives
priorities1249153priorities
probities13312653probities
prodigies1346953prodigies
putridities1444913putridities
quiddities2143273quiddities
rancidities1445593rancidities
rarities8316333_rarities
raucities1148163raucities
righties12711573_righties
rigidities1246293rigidities
salinities10410953salinities
solidities1149503solidities
tepidities1347713tepidities
timidities1346553timidities
torpidities1444803torpidities
torridities1244493torridities
triunities1046103triunities
tumidities1345893tumidities
turbidities14174553turbidities
turgidities13174263turgidities
uridines989513uridi_nes
utilities9610803utilities
vagilities1447953vagilities
varieties1259203vari_eties
varsities1239243var_sities
viduities1346113_viduities
virilities1379123virilities

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 Filter1786911486410.483369960.7
2DLD Change Limit1486411106.75022020.9
3Display Results1101100.0631746.0
 (SQL Overall)1786911107.29624491.6
 
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.