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

105 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
latinity113881(None) 
aminity12310512_aminity
caninity1338062caninity
lability13710832lability
latinize17610562latinize
nativity1446642nativity
salinity1138892salinity
ability12311443_ability
acidity1338593_acidity
activity1647593activity
affinity1744993affinity
agility1148653_agility
algidity1345283algidity
alkalinity1752483alkalinity
alterity1149853alterity
amenity1238333_amenity
anility10312723_anility
anticity13313603anticity
aridity11510113_aridity
avidity1436483_avidity
basicity1546323basicity
bovinity1645023bovinity
captivity1944683captivity
dainty105311473da_in_ty
divinity1546173divinity
elasticity1575383elasticity
equinity2045663equinity
facility1638253facility
facticity1945963facticity
fatality1438443fatality
fatuity1336043fat_uity
felinity1447293felinity
feminity1647553feminity
fetidity1545863fetidity
futility1446983futility
infinity1447323infinity
kainit10414483ka_init_
kainite1149543ka_inite
kainits1137763ka_inits
labiality1446363labiality
laciniate1156843laciniate
laity85318903la___ity
laminary13337253laminary
laminate103014633laminate
laminin939973lamini_n
laminins1039133laminins
laminitis1146243laminitis
lanosity1146353lanosity
lapidify1742803lapidify
lastingly1337243lastingly
latency1236033laten_cy
latening9711493latening
latent64124303laten_t_
latently1146353latently
latents75214313laten_ts
laterite8716353laterite
latina65621143latin__a
latinas74416463latin_as
latinities10410163latinities
latinized1988533latinized
latinizes18610153latinizes
latino64120473latin__o
latinos73613803latin_os
laxity1637273la__xity
lenity9612713l__enity
liability14128493liability
linty87126563l__in_ty
lividity1545093lividity
lucidity1445503lucidity
malignity1543653malignity
maternity1444983maternity
maturity1367443maturity
motility1338733motility
motivity1646233motivity
natality1139193natality
painty114714753pa_in_ty
paternity1444843paternity
patinate103016313patinate
patining11312303patining
patinize19610773patinize
placidity1744243placidity
plasticity1765603plasticity
platinic1237073platini_c
platinize2068103platinize
rabidity1446583rabidity
rainily10310433ra_inily
rapidity1446273rapidity
relativity1645243relativity
retinite8314853retinite
sanity9316203sa__nity
sapidity1446433sapidity
satiety1038203sati_ety
satinet7325283satinet_
satinets8311733satinets
satiny93817983satin__y
tactility1446833tactility
tinily94014433__tinily
trinity10310843_trinity
utility1038713_utility
vagility1546323vagility
validity1545993validity
vanity12311943va__nity
vapidity1745193vapidity
vicinity1645823vicinity
volatility1644863volatility

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.406440125.6
2DLD Change Limit1461621056.97020970.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.42224075.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.