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

166 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
aminity1231051(None) 
amenity1238331amenity
ability12311442ability
acidity1338592acidity
affinity1744992affinity
agility1148652agility
amanita9310452amanita
aminic104413512amini_c
amity10416092am__ity
anility10312722anility
aridity11510112aridity
avidity1436482avidity
caninity1338062caninity
feminity1647552feminity
latinity1138812latinity
minify1439252_minify
minty106323902_min_ty
salinity1138892salinity
trinity10310842trinity
acidify1645243acidify
acini75718983acini__
acinic104713543acini_c
aconite9315473aconite
acridity1446913acridity
activity1647593activity
acuity1139373a_cuity
agminate1139243agminate
airily93014823a_irily
algidity1345283algidity
alining81917043alining
almighty1742683almighty
alunite7311633alunite
amanitas1048533amanitas
amanitin1048463amanitin
ambiguity1752083ambiguity
ambit94223713am_bit_
ambits103713413am_bits
ament76036543amen_t_
amentia9310153amentia
aments85219803amen_ts
amiably1438303amiably
amici94217393amici__
amidic114012873amidi_c
amidin94015673amidi_n
amidine103613853amidine
amidins103713103amidins
amidst94913233amidst_
amin66042253amin___
amine75835383amin__e
amines84727983amin_es
aminities11312913aminities
amino75425503amin__o
amins75534323amin__s
amirate91115953amirate
amities9317383amities
ammonify1843353ammonify
ammonite1249143ammonite
amnesty1244823amnesty
amnia75918643am_ni_a
amnic95516243am_ni_c
amnio75218053am_ni_o
amnion84812053am_nion
amnios84912523am_nios
amniote936963amniote
amosite9313163amosite
amplify1744083amplify
amrita8411133am_rita
anality10313633anality
annuity1045543annuity
anticity13313603anticity
arenite71017713arenite
asinine7310723asinine
asininity1243473asininity
atomicity1645513atomicity
aunty85919813a_un_ty
axiality1856763axiality
basicity1546323basicity
binit76431583_binit_
binits85716673_binits
bovinity1645023bovinity
crinite9513633crinite
dainty105311473dain_ty
damnify1643453dam_nify
dignity1236463dignity
dimity12310483_dimity
divinity1546173divinity
equinity2045663equinity
facility1638253facility
felinity1447293felinity
finite9316823_finite
finito9310303_finito
fixity19427813_fixity
flinty126112493flin_ty
glinty106910693glin_ty
humanity1646313humanity
humidity1745233humidity
humility1646103humility
immunity1544733immunity
impunity1544653impunity
inanity1039503inanity
infinity1447323infinity
kainit10414483kainit_
kainite1149543kainite
kainits1137763kainits
lability13710833lability
laminary13337253laminary
laminate103014633laminate
laminin939973lamini_n
laminins1039133laminins
laminitis1146243laminitis
lenity9612713_lenity
linty87126563_lin_ty
magnify1634533magnify
mainly11411493main_ly
mainstay1344033mainstay
malignity1543653malignity
manito8518693_manito
manitu8315823_manitu
mannite9312903mannite
mighty154310213_mighty
milty104720073_mi_lty
minacity1547373_minacity
mincy125817413_min_cy
mingy115520183_min_gy
mini65634563_mini__
minim97321603_mini_m
minima105512653_minima
minims104514813_minims
mining94225453_mining
minion83416243_minion
minis75432993_mini_s
minish115216303_minish
ministry1385793_ministry
minium106014423_minium
minny104518663_min_ny
minority1347933_minority
mint66758063_min_t_
mints76834043_min_ts
minute83414293_minute
misty106120453_mi_sty
mity95528213_m__ity
nativity1446643nativity
ninety9510963_ninety
painty114714753pain_ty
pinite8321243_pinite
pointy114913283poin_ty
privity15268323privity
rabidity1446583rabidity
rainily10310433rainily
ramosity1345893ramosity
rapidity1446273rapidity
sanity9316203_sanity
sapidity1446433sapidity
shinily13268933shinily
timidity1445423timidity
tinily94014433_tinily
triunity1145073triunity
tumidity1444963tumidity
unity84918493__unity
utility1038713utility
vagility1546323vagility
validity1545993validity
vanity12311933_vanity
vapidity1745193vapidity
vicinity1645823vicinity
vinify1536923_vinify

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.796224486.2
2DLD Change Limit1340271667.62617575.0
3Display Results1661660.0602766.7
 (SQL Overall)1786911668.48221067.1
 
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.