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

123 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
salinity113889(None) 
aminity12310512_aminity
caninity1338062caninity
felinity1447282felinity
latinity1138812latinity
malignity1543652malignity
salacity1347852salacity
salinize1739682salinize
sanity9316202sa__nity
sapidity1446432sapidity
solidity1248112solidity
validity1545992validity
ability12311443_ability
acidity1338593_acidity
affinity1744983affinity
agility1148653_agility
algidity1345283_algidity
alining81917043_alining
alkalinity1752483alkalinity
alunite7311633_alunite
amenity1238333_amenity
anility10312723_anility
aridity11510113_aridity
asininity1243473asininity
avidity1436483_avidity
basicity1546313basicity
bovinity1645023bovinity
calamity1547753calamity
dainty105311473da_in_ty
divinity1546163divinity
equinity2045653equinity
facility1638243facility
falsity1335903fal_sity
felicity1647913felicity
feminity1647543feminity
flinty126112493_flin_ty
galenite91210063galenite
gelidity1345573gelidity
glinty106910693_glin_ty
helicity1648503helicity
infinity1447313infinity
kainit10414483ka_init_
kainite1149543ka_inite
kainits1137763ka_inits
kaolinite1344043kaolinite
lability13710833lability
lenity9612713__lenity
linty87126563__lin_ty
melinite10411743melinite
nativity1446633nativity
painty114714753pa_in_ty
rabidity1446583rabidity
rainily10310433ra_inily
rapidity1446273rapidity
sagacity1445243sagacity
saining83621393sa_ining
saint55147073sa_in_t_
saintly1039343sa_intly
saints65122423sa_in_ts
salability1548523salability
salicin9311223salici_n
salicine10311703salicine
salicins10310933salicins
saliency13125393saliency
salient7419763salient_
saliently1245773saliently
salients839563salients
salified12310363salified
salifies11314793salifies
salify12311373sal__ify
salimetry1444533salimetry
salina64221123salin__a
salinas73116093salin_as
saline65132703salin__e
salines74029413salin_es
salinities10410953salinities
salinized1947383salinized
salinizes1839153salinizes
salivary1444733salivary
salivate11310013salivate
salsify1334703sal_sify
saltily10310543sal_tily
salty85524383sal___ty
salubrity1443163salubrity
sanctity1345593sanctity
sanguinity1453053sanguinity
saponify1644183saponify
saponite10410533saponite
satiety1038203sati_ety
satinet7325283satinet_
satinets8311733satinets
satiny93817983satin__y
savingly1537313savingly
selenite81713103selenite
senility1139683senility
serenity1168963serenity
shinily13268933s_hinily
silicify1644273silicify
slainte738543slain_te
slanty95114843s_lan_ty
slimily1247713s_limily
slinkily1534853s_linkily
slinky13399103s_lin_ky
slitty9329163s_li_tty
solemnity1443543solemnity
solicit9315743solicit_
solicits10311023solicits
solidify1544193solidify
splining11310773splining
splint85223283splin_t_
splints94511743splin_ts
squinty19287063squin_ty
stability14410083stability
stolidity1344683stolidity
suability1448593suability
sublimity1644933sublimity
sylvinite1542923sylvinite
trinity10310843_trinity
usability1447163usability
vagility1546323vagility
vanity12311933va__nity
vapidity1745193vapidity
vicinity1645813vicinity

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621236.61022112.3
3Display Results1231230.0462673.9
 (SQL Overall)1786911237.07925242.4
 
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.