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

175 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
incenses10241100(None) 
incense92410301incense_
incensed11277951incensed
censes83721802__censes
incases93615972inc_ases
incented112412542incented
incenter102212092incenter
incenters112510302incenters
incents92414532incen_ts
incests92711382ince_sts
incises93414892inc_ises
incloses101610532incloses
increases1157382increases
incuses93514852inc_uses
indenes82916252inden_es
ingenues947102ingenues
intense72511902intense_
intenser8199442intenser
intensest949102intensest
inverses112410982inverses
licenses10118922licenses
niceness1039842niceness
accesses1287493accesses
ancones93116343ancon_es
ancresses1138413ancresses
asceses938623asce_ses
avenses1049643_avenses
bicepses1443873bicepses
biocenoses1443973biocenoses
ceases84427073__ceases
cense75121403__cense_
censed94016323__censed
censer84516583__censer
censers94313903__censers
census84310303__census
cesses84221363__cesses
condenses12710133condenses
deceases11410153deceases
defenses1237913defenses
dickenses1645073dickenses
dioceses1137113dioce_ses
dispenses121210763dispenses
encases93116053enc_ases
enceintes1145673enceintes
enchases13310273enchases
encloses10911053encloses
ententes8312773ententes
excesses1736753excesses
expenses17138373expenses
fineness11310643fin_eness
finesses111912343fin_esses
flenses1039473_flenses
iceless9219963i_celess
iciness938863i_ciness
icones84616383i_con_es
ictuses938303i_ctuses
idleness936843idleness
idlesses936003idlesses
ileuses738673i_leuses
immense1135293immense_
immenser1244173immenser
immensest1343903immensest
immerses1235953immerses
inaneness948383inaneness
inanes62519803in_an_es
incages103013883inc_ages
incanted11259543incanted
incants92012803incan_ts
incase83615283inc_ase_
incased103612393inc_ased
incensing1297663incensing
incent83320723incen__t
incentives1578043incentives
incepted13177773incepted
incepts11238283ince_pts
incest82918743ince_s_t
inches114419673inc__hes
incidences1547133incidences
incise83515333inc_ise_
incised102911583inc_ised
incites93218483inc_ites
inclasps1244353inclasps
inclines10313143inclines
inclose9910223inclose_
inclosed1197613inclosed
incloser10106733incloser
inclosers11155563inclosers
includes1146023includes
incomes11712373inc_omes
inconnus1044293inconnus
incorpses1345173incorpses
increase1066453increase_
increased1245533increased
increaser1154573increaser
increasers1243313increasers
incross937663incros_s
incrosses1146033incrosses
incrusts1036253incrusts
incubuses1343533incubuses
incudes10319523inc_udes
incurves1336393incurves
incuse83513573inc_use_
incused102911173inc_used
indene73215373inden_e_
indented101811733indented
indenter92311443indenter
indenters102710033indenters
indents83114663inden_ts
indexes15339453inde_xes
indorses968063indorses
infantes11249633infantes
infests10279793infe_sts
infuses102711873in_fuses
ingenue847133ingenue_
ingests83210983inge_sts
ingresses1038533ingresses
inheres10315173inhe_res
inkiness1238693inkiness
inmeshes1345613inmeshes
innerness946913innerness
innerves1158013innerves
innocences14106073innocences
intended102310413intended
intendeds11265743intendeds
intender93310443intender
intenders10219373intenders
intends8239963inten_ds
intensely1245383intensely
intensives1347393intensives
intents72115703inten_ts
internees93014843internees
internes82721233internes
intersex15209733intersex
intines7921113intin_es
intones7816543inton_es
inulases838763inulases
invented122510663invented
inventer112410843inventer
inventers12269533inventers
invents102812053inven_ts
inverness1247133inverness
inverse10249643inverse_
inversed12269283inversed
invests10319683inve_sts
inweaves1445043inweaves
kineses113111253kin_e_ses
lenses64620893__lenses
licences12129323licences
license9148423license_
licensed11145723licensed
licensee10166303licensee
licensees1184473licensees
licenser10155883licenser
licensers11114583licensers
lucences12137313lucences
menses84222453__menses
missenses1148033missenses
nenes55329673_n_en_es
nesses64718323_n_esses
nicenesses12310353nicenesses
niceties10310863niceties
nonsenses948343nonsenses
offenses1443833offenses
oneness7512143on_eness
pinenes93416673pin_en_es
princesses14206263princesses
recesses10312323recesses
scenes84520353_scen_es
senses63923943__senses
spenses92913573_spenses
tenses64722553__tenses
uncases93516553unc_ases
uncloses10910943uncloses
uneases73316263un_eases
unfences1337933unfences

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.406440125.6
2DLD Change Limit1461621756.46622604.7
3Display Results1751750.0632777.8
 (SQL Overall)1786911756.93525766.5
 
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.