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

159 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
aridity1151011(None) 
acidity1338591acidity
acridity1446911acridity
avidity1436481avidity
ability12311442ability
acidify1645242acidify
agility1148652agility
algidity1345272algidity
aminity12310512aminity
anility10312722anility
aridly105513702arid_ly
crudity1336042crudity
privity15268312privity
rabidity1446582rabidity
rapidity1446272rapidity
sapidity1446432sapidity
trinity10310842trinity
validity1545992validity
vapidity1745192vapidity
viridity1545902viridity
abiding11510503abiding
acidic113612133acidi_c
acidly125211793acid_ly
acidy117214893acid__y
acridine1139553acridine
acridly13396533acrid_ly
activity1647583activity
acuity1139373a_cuity
adit56443653a__dit_
adits66523713a__dits
affinity1744983affinity
aiding84423613a_iding
airdate8311323airdate
airily93014823a_irily
amenity1238333amenity
amidic114012863amidi_c
amidin94015663amidi_n
amidine103613853amidine
amidins103713093amidins
amidst94913233amidst_
amity10416093a__mity
anality10313633anality
annuity1045543annuity
anticity13313603anticity
apriority1444743apriority
arability14411003arability
arenite71017713arenite
ariary94114203ari_ary
arid57642713arid___
arider74717743arid_er
aridest8316143aridest
aridities10911633aridities
arietta788903arietta
ariette7312373ariette
aright103817663aright_
arising83619973arising
arista6415293ari_sta
aristo6414033ari_sto
armpit10811093armpit_
armpits1157123armpits
artily92814713ar_tily
arty77531313ar___ty
assiduity1352233assiduity
atrocity1347213atrocity
audit62527883a_udit_
audits72814113a_udits
aurality1139223aurality
avidin103510843avidi_n
avidins11349003avidins
avidly13548783avid_ly
axiality1856763axiality
basicity1546313basicity
bifidity1743703bifidity
brevity1534783brevity
caninity1338063caninity
cariosity1446213cariosity
credit9315193credit_
credits1039973credits
criminy14268453criminy
crinite9513633crinite
cupidity1644873cupidity
dimity12310473_dimity
drifty13418223dri_fty
erudite838483erudite
facility1638243facility
fervidity1943023fervidity
fetidity1545853fetidity
fixity19427803_fixity
floridity1644233floridity
fluidity1544913fluidity
frigidity1743003frigidity
fruity12429693fr_uity
gelidity1345573gelidity
gravidity1743533gravidity
gravity1437183gravity
griding103014973griding
grimily1336523grimily
gritty10338403gri_tty
hardily143310273har_dily
heredity1546493heredity
humidity1745223humidity
hybridity2172803hybridity
iridic9328743iridi_c
iridium1046303iridium
lability13710833lability
lapidify1742803lapidify
latinity1138813latinity
lividity1545083lividity
lucidity1445493lucidity
morbidity1744143morbidity
mucidity1645523mucidity
nativity1446633nativity
nidify1336763_nidify
nudity1037993_nudity
oddity1135243_oddity
orality101111683orality
parity114719873par__ity
placidity1744243placidity
pricily142710283pricily
priding113317543priding
priority1347443priority
privily15207623privily
probity14299683probity
prodigy1435573prodigy
putridity1544193putridity
quiddity2242693quiddity
rabbity14266303rabbity
raiding93617593raiding
rainily10310433rainily
raisiny10319923raisiny
rancidity1544313rancidity
rarity93615493_rarity
raucity1235853raucity
ridgy104110643_rid_gy
riding84325963_riding
ridley10169543_ridley
righty135011833_righty
rigidity1345253rigidity
salinity1138893salinity
solidity1248113solidity
tardily11269583tar_dily
tepidity1445603tepidity
tidily102811393_tidily
timidity1445413timidity
torpidity1543833torpidity
torridity1344243torridity
trilith10310513trilith
triunity1145073triunity
tumidity1444953tumidity
turbidity15144293turbidity
turgidity14153313turgidity
uridine81311213uridine
utility1038703utility
vagility1546323vagility
variety1337743vari_ety
varsity1356673var_sity
viduity1445343_viduity
virility1447733virility
wristy12509703wri_sty

Search took 9 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.1731032896.0
2DLD Change Limit1340271598.20316338.8
3Display Results1591590.0632523.8
 (SQL Overall)1786911598.43921174.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.