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

197 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
incense9241030(None) 
incensed11277951incensed
incenses102411001incenses
intense72511901intense
cense75121402__cense
immense1135292immense
incase83615282inc_ase
incent83320722incen_t
incented112412542incented
incenter102212092incenter
incents92414532incents
incest82918742ince_st
incise83515332inc_ise
inclose9910222inclose
increase1066452increase
incuse83513572inc_use
indene73215372inden_e
indenes82916252indenes
ingenue847132ingenue
intenser8199442intenser
inverse10249642inverse
license9148422license
ancone83916953ancon_e
ancones93116343ancones
anenst63514983an_enst
biocenose1343543biocenose
cease75227653__cease
censed94016323__censed
censer84516583__censer
censes83721803__censes
condense1179613condense
decease1049523decease
defense1137503defense
dense65923503__dense
diocese1036853dioce_se
dispense11129783dispense
encase83714363enc_ase
enceinte1046263enceinte
enchase1239463enchase
enclose999993enclose
entente7412953entente
eocene8311613eocen_e
expense16127873expense
finesse10187643fin_esse
flense938903_flense
ices66129643i_ce_s_
icones84616383i_cones
icons76516493i_cons_
idlesse834193idlesse
immenser1244173immenser
immerse1145793immerse
inane52820343in_an_e
inanes62519803inanes_
inanest72115363inanest
incage93513623inc_age
incages103013883incages
incant82418513incan_t
incanted11259543incanted
incants92012803incants
incased103612393inc_ased
incases93615973inc_ases
incensing1297663incensing
incenters112510303incenters
incentive1489603incentive
incept102712753ince_pt
incepted13177773incepted
incepts11238283incepts
incests92711383incests
inchers123912523inchers_
inches114419673inches_
incidence1447603incidence
incised102911583inc_ised
incises93414893inc_ises
incite83618733inc_ite
incites93218483incites
inclasp1145303inclasp
incline9314643incline
inclines10313143inclines
inclosed1197613inclosed
incloser10106733incloser
incloses101610533incloses
include1036083include
incogs937903incogs_
income10712093inc_ome
incomes11712373incomes
inconnu945053inconnu
incony1139083incon_y
incorpse1244693incorpse
increased1245533increased
increaser1154573increaser
increases1157383increases
increate10312203increate
incross937663incross
incrust949203incrust
incudes10319523incudes
incurs83012283incurs_
incurve1236633incurve
incus73315053inc_us_
incused102911173inc_used
incuses93514853inc_uses
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
innocence1395993innocence
inns46920933in__ns_
inphase1245383inphase
inruns6359513inruns_
insane6314893insan_e
insensate945393insensate
insets64016133insets_
intend72310373inten_d
intended102310413intended
intender93310443intender
intends8239963intends
intensely1245383intensely
intensest949103intensest
intensive1248403intensive
intent63122773inten_t
intents72115703intents
interne73218153interne
internee82718523internee
internes82721233internes
interns73116773interns_
inters64328053inters_
intersex15209733intersex
intine61021983intin_e
intines7921113intines
intone61115433inton_e
intones7816543intones
inulase739413inulase
inurns63310983inurns_
invent93316363inven_t
invented122510663invented
inventer112410843inventer
invents102812053invents
inversed12269283inversed
inverses112410983inverses
invest93014843inve_st
inweave1344723inweave
lense54523433__lense
licence11119363licence
licensed11145723licensed
licensee10166303licensee
licenser10155883licenser
licenses10118923licenses
licente91210893licente
lindens839413lindens_
linens64818393lin_ens_
lucence11148003lucence
mense75025633__mense
mincers113714853mincers_
minces104420803mince_s_
miocene1147923miocen_e
missense1037963missense
nene45932063_n_en_e
nenes55329673_n_enes
niceness1039843niceness
nicest82315663nice_st
nicoise937923nicoise
nonsense847393nonsense
offense1343683offense
pincers113916503pincers_
pinene82915643pin_en_e
pinenes93416673pin_enes
pinkens13419643pinkens_
princesse13264403princesse
scene77220573_scen_e
scenes84520353_scenes
sense55526823__sense
sincere9310553since_re
spense83912433_spense
tense55225843__tense
uncase83817433unc_ase
unclose91111643unclose
unease63816643un_ease
unfence1239193unfence
unpens82511013unpens_
wincers123415363wincers_
winces114819113wince_s_
winceys15395523winceys_

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 Filter1786911340270.420425454.8
2DLD Change Limit1340271976.09621986.1
3Display Results1971970.0762592.1
 (SQL Overall)1786911976.59227107.3
 
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.