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

206 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
intense7251190(None) 
incense92410301incense
intenser8199441intenser
entente7412952entente
immense1135292immense
incensed11277952incensed
incenses102411002incenses
indene73215372inden_e
indenes82916252indenes
ingenue847132ingenue
intend72310372inten_d
intended102310412intended
intender93310442intender
intends8239962intends
intensely1245382intensely
intensest949102intensest
intensive1248402intensive
intent63122772inten_t
intents72115702intents
interne73218152interne
internee82718522internee
internes82721232internes
interns73116772interns_
inters64328052inters_
intersex15209732intersex
intine61021982intin_e
intines7921112intines
intone61115432inton_e
intones7816542intones
inverse10249642inverse
tense55225842__tense
anenst63514983an_enst
antenna746383antenna
antennae845453antennae
antes56334323ante_s_
antisense946613antisense
butene8312623buten_e
butenes9313033butenes
catenae9311373catenae
cense75121403__cense
condense1179613condense
defense1137503defense
dense65923503__dense
detente83313603detente
dispense11129783dispense
ententes8312773ententes
enters64425643enters_
enthuse1046963enthuse
expense16127873expense
finesse10187643fin_esse
flense938903_flense
hinters103719583hinters_
idlesse834193idlesse
immenser1244173immenser
immerse1145793immerse
inane52820343in_an_e
inanes62519803inanes_
inanest72115363inanest
incase83615283in_case
incent83320723incen_t
incented112412543incented
incenter102212093incenter
incents92414533incents
incest82918743ince_st
incise83515333in_cise
inclose9910223inclose
increase1066453increase
incuse83513573in_cuse
indent73021243inden_t
indented101811733indented
indenter92311443indenter
indents83114663indents
indexes15339453indexes
indorse8108193indorse
infante101910883infante
infers93615443infers_
infest93315433infe_st
infuse93110573in_fuse
ingenues947103ingenues
ingest73119003inge_st
inhere9313713inhe_re
inheres10315173inheres
inions64417003inions_
inkers104018833inkers_
inlets63915573inlets_
inmesh1134863inme_sh
inners63919353inners_
innerve1056753innerve
inns46920933in__ns_
inphase1245383inphase
inruns6359513inruns_
insane6314893insan_e
insensate945393insensate
insets64016133insets_
instance1049883instance
insteps936573insteps_
intake10510863int_ake
intakes11310943intakes
integer837993integer
intendeds11265743intendeds
intenders10219373intenders
intensify1543993intensify
intension948493intension
intensity1247203intensity
intensives1347393intensives
intently1149823intently
inter55028493inte__r
interage9314493interage
interbed112413103interbed
interest8319183interest
interfuse1247433interfuse
interim9912873interim
intern64016543inte_rn
internal8414083internal
interned93016653interned
internees93014843internees
internist9414883internist
internode1048763internode
interpose11410463interpose
interred92615263interred
interrex15249823interrex
intersect11412113intersect
intertie8317613intertie
intimae9109753intimae
intime81014273int_ime
intis55121643int_is_
intitle7610583intitle
intonate8310923intonate
intoned8811993intoned
intoner7811673intoner
intrench1396593intrench
introns73515023introns_
introrse846043introrse
intros64215773intros_
intrude837403intrude
intrust7311493intrust
inturns73210133inturns_
intwine1038513intwine
intwines1138043intwines
intwist1038043intwist
inulase739413inulase
inurns63310983inurns_
invent93316363inven_t
invented122510663invented
inventer112410843inventer
invents102812053invents
inversed12269283inversed
inverses112410983inverses
invest93014843inve_st
inweave1344723inweave
itemise997453i_temise
items7499613i_tems_
ketene106613003keten_e
ketenes114813503ketenes
kittens11347583kittens_
latens64620213latens_
lense54523433__lense
license9148423license
lindens839413lindens_
linens64818393lin_ens_
lintels73311163lintels_
linters73822633linters_
listens74014133listens_
mense75025633__mense
minters93822473minters_
missense1037963missense
mittens9349883mittens_
nene45932063_n_en_e
nenes55329673_n_enes
niterie7313743niterie
niters64624213niters_
nites55736343nite_s_
nitons64614903nitons_
nonsense847393nonsense
offense1343683offense
patens84820863patens_
pentene9313793penten_e
pentenes10315633pentenes
pinene82915643pin_en_e
pinenes93416673pin_enes
pinkens13419643pinkens_
potence11711363potence
pretense10199823pretense
retene69224273reten_e
retenes76324623retenes
sense55526823__sense
sentence1099863sentence
sinters74024083sinters_
spense83912433_spense
tease55428713__tease
tenge65720443__tenge
tens45647413__tens_
tensed74817833__tensed
tenser64919433__tenser
tenses64722553__tenses
terse55026823__terse
tinters74221113tinters_
unease63816643un_ease
unfence1239193unfence
unpens82511013unpens_
untended102611153untended
untented92613413untented
untune62511603untun_e
untunes72211253untunes
vitesse1044583vitesse
winters103720483winters_

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 Filter1786911340270.436409841.7
2DLD Change Limit1340272067.09318895.7
3Display Results2062060.0802575.0
 (SQL Overall)1786912067.60923484.2
 
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.