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

141 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
gentians93756(None) 
gentian8310101gentian_
dentins83419222denti_ns
genitals937242genitals
gentiles93713522gentiles
mentions10312892mentions
tertians839102tertians
venetians1244672venetians
agential958153agentia_l
agenting1039383agenti_ng
agentings1134443agentings
agentives1346443agentives
amentias1039413amentia_s
antiars7314623_antiars
banians9312033ban_ians
benthons1337973benthons
benzins1838693benzi_ns
cantinas102713783cantinas
centals94317053cent_als
centas85020703cent_a_s
centiare1067203centiare
centiares1167653centiares
centiles103615813centiles
centimes124012613centimes
centimos12507323centimos
centrals102712033centrals
contains10316533contains
countians1147333countians
denials84114133den_ials
dentals83915393dent_als
dentils84115583denti_ls
dentin73919573denti_n_
dentinal939503dentinal
dentine83320243denti_ne
dentines93418403dentines
denting94422183denti_ng
dentists939263dentists
destains9311813destains
detains83716093de_tains
dextrans1695983dextrans
egestions1046703egestions
egyptians1551423egyptians
enations83316903_enations
encinas938723_encinas
ensigns836353_ensigns
entails7912823_entails
entia5318203_entia__
entices91616333_entices
entires71517783_entires
entrains8312963_entrains
entrant7318873_entrant
entrants8311753_entrants
entraps9109763_entraps
fenthions1544233fenthions
fetials103711743fe_tials
fontinas1136853fontinas
fustians1146403fustians
gelatins93414093gelati_ns
gelations102513093gelations
generals9109333generals
genetics11128613geneti_cs
genevas1185253geneva_s
genial74917613gen_ia_l
genies75324943gen_i_es
genipaps1342163genipaps
genips9469943gen_i_ps
genital849793genita_l
genitives1346663genitives
genitors937423genitors
genius74512923gen_i_us
genoas74013623gen_oa_s
genoises939253genoises
gentes75324163gent__es
gentil74115123genti__l
gentile83515293genti_le
gentles83714343gent_les
gentling1048453gentling
gentoos838633gent_oos
gentrices1258913gentrices
gentries91315263gentries
gents65729613gent___s
genuine838373genui_ne
germans1079473ge_rmans
getas65421483ge_t_a_s
getting93316563getti_ng
gratins84119183grati_ns
henting113719653henti_ng
hessians1145053hessians
hetmans12187593he_tmans
lectins92515003lecti_ns
lections102413843lections
lenitions939473lenitions
lentils73912973lenti_ls
lentisks1244413lentisks
leptins92412693lepti_ns
lesbians1043603lesbians
martians103111613martians
medians103214213me_dians
menials94015683men_ials
mention9314373mention_
muntins92715133munti_ns
pectins112315233pecti_ns
pensions10311693pensions
pentads1039523pent_ads
pentane9415743pent_ane
pentanes10316083pent_anes
pentosans1145183pentosans
pertains102113423pertains
renins64526453ren_i_ns
rennins74013413renni_ns
rentals74017473rent_als
rentiers83311763rentiers
renting84026853renti_ng
retains74522253re_tains
retinas74819353re_tinas
sections102714703sections
seitans73312303seit_ans
sentient8313633sentient
sentients948463sentients
sentimos10407423sentimos
sestinas8249133sestinas
sextains15246813sextains
sextans14349263sext_ans
suntans72111733sunt_ans
tenias64720073ten_ia_s
tenpins9410073tenpi_ns
tensions8310223tensions
tenting84621153tenti_ng
tertials8510073tertials
tertian7511193tertian_
titians72710453_titians
venations12311723venations
venetian1146073venetian_
venins93816703ven_i_ns
ventails1139823ventails
venting114218093venti_ng
ventrals112910003ventrals
xanthans1845693xanthans
xenias133712973xen_ia_s
yentas94614213yent_a_s
zeatins16311733zeati_ns

Search took 7 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 Limit1461621416.32623105.0
3Display Results1411410.0632238.1
 (SQL Overall)1786911416.81226231.8
 
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.