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

319 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
incents9241453(None) 
incants92012801incants
incent83320721incent_
incepts11238281incepts
incests92711381incests
indents83114661indents
intents72115701intents
invents102812051invents
accents113511232accents
ancients1098972ancients
ascents93812552ascents
cents74730332__cents
concents122516602concents
docents102810802docents
incant82418512incant_
incense92410302incense
incenses102411002incenses
incented112412542incented
incenter102212092incenter
incenters112510302incenters
incept102712752incept_
incest82918742incest_
incidents1246802incidents
indenes82916252indenes
indent73021242indent_
inerts64517022in_erts
infants102210772infants
infects12279712infects
infests10279792infests
ingests83210982ingests
injects16257452injects
inlets63915572inle_ts
innocents1145312innocents
insects93710842insects
inserts74013992inserts
insets64016132inse_ts
intends8239962intends
intent63122772intent_
invent93316362invent_
inverts103211952inverts
invests10319682invests
scents85317022_scents
absents93510723absents
accent105116263accent_
accepts13356353accepts
advents11309473advents
agents74816293_agents
ailments1039433ailments
aments85219803_aments
ancient9514733ancient_
ancones93116343ancones
anenst63514983an_enst
anent54931843an_ent_
anoints7311063anoints
argents84014853argents
arpents93613083arpents
ascends10388203ascends
ascent84519653ascent_
assents74512223assents
bents76033693__bents
brents84717273_brents
cants77036943__cants
celts75325783__celts
cements112714223cements
cent67451013__cent_
centas85020703__centas
cento76625173__cento
centos85920463__centos
centu76119413__centu
clients938093clients
coinvents1445663coinvents
conceits122813613conceits
concent114422513concent_
concepts143110303concepts
concerts123016063concerts
consents102715893consents
contents104018213contents
convents132614603convents
cunts76125123__cunts
decants103514443decants
deceits102810883deceits
decent94023703decent_
dements103016623dements
dents65031803__dents
descents112511203descents
detents83615153detents
diluents946053diluents
discants112912023discants
discepts1336743discepts
dissents93411863dissents
docent92918683docent_
eluents738703eluents
enceinte1046263enceinte
enceintes1145673enceintes
enchants1347833enchants
encinas938723encinas
encysts1244313encysts
entente7412953entente
ententes8312773ententes
events94814073_events
excepts1885203excepts
extents142610173extents
facets116316653face_ts
figments1446943figments
fitments1376793fitments
foments122912053foments
gents65729613__gents
gerents82612923gerents
ginsengs1042653ginsengs
hents87330743__hents
ices66129643i_ce__s
icings9428453i_cings
icones84616383i_cones
icons76516493i_con_s
ignescents1373383ignescents
impends12376803impends
inanes62519803in_anes
inanest72115363inanest
inbeings1134603inbeings
incages103013883incages
incanted11259543incanted
incases93615973incases
incensed11277953incensed
incenting12912063incenting
incentive1489603incentive
incentives1578043incentives
incepted13177773incepted
inceptor1246023inceptor
inceptors1345773inceptors
inchers123912523inchers
inches114419673inc_hes
incident11410203incident_
incipits1246263incipits
incises93414893incises
incitants1196193incitants
incite83618733inc_ite
incites93218483incites
inclines10313143inclines
inclips1135963inclips
incogs937903inc_ogs
incomes11712373incomes
inconnu945053inconnu
inconnus1044293inconnus
incony1139083incon_y
increate10312203increate
increments14410103increments
incross937663incross
incrust949203incrust
incrusts1036253incrusts
incubus1144743incubus
incudes10319523incudes
incult82414773incult_
incumbents1644283incumbents
incurs83012283inc_urs
incus73315053inc__us
incuses93514853incuses
indecent11411273indecent_
indene73215373inden_e
indented101811733indented
indenter92311443indenter
indenters102710033indenters
indentor9288513indentor
indentors10278313indentors
indexes15339453indexes
indicants1247203indicants
indicts103210723indicts
indigents11208273indigents
inducts10259573inducts
indults8289493indults
inept73622153in_ept_
inert53234373in_ert_
infant92315133infant_
infanta10237253infanta
infantas11246003infantas
infante101910883infante
infantes11249633infantes
infect113413443infect_
infernos1145903infernos
infers93615443infe_rs
infest93315433infest_
inflects1336193inflects
influents1245393influents
ingenue847133ingenue
ingenues947103ingenues
ingest73119003ingest_
ingesta8357863ingesta
ingots7912063in_gots
inheres10315173inheres
inherits11310103inherits
inions64417003inion_s
inject153210233inject_
inkers104018833inke_rs
inkpots1335173inkpots
inlands838783inlands
inlet53732403inle_t_
inners63919353inne_rs
innings8329443innings
innocent1048163innocent_
inns46920933in__n_s
inputs837703in_puts
inquests1744943inquests
inruns6359513inrun_s
inseams9307903inseams
insect83916583insect_
insert64325253insert_
inset54430863inse_t_
insists739083insists
insolents9137523insolents
inspects1255863inspects
instants8910153instants
insults7268963insults
intend72310373inten_d
intense72511903intense
intently1149823intently
internes82721233internes
interns73116773interns
inters64328053inte_rs
intines7921113intines
intones7816543intones
intorts7310973intorts
intrants8312863intrants
intreats8311543intreats
intuits7310313intuits
inurns63310983inurn_s
invented122510663invented
inventer112410843inventer
inventers12269533inventers
inventor11298153inventor
inventors12288253inventors
invert94120083invert_
invest93014843invest_
inwinds11216273inwinds
islets64513083isle_ts
laments94314853laments
lancets93411163lance_ts
latents75214313latents
licente91210893licente
lindens839413linden_s
linecuts1094553linecuts
linens64818393lin_en_s
liniments1146613liniments
linnets739833linne_ts
loments93413473loments
lucent8313823lucent_
mincers113714853mince_rs
minces104420803mince__s
minuends1143893minuends
minuets9259853minue_ts
moments113113123moments
neats55931903_n_eats
nenes55329673_n_enes
nerts55924983_n_erts
nests55728003_n_ests
nets45941533_n_e_ts
netts55320723_n_etts
newts86015283_n_ewts
niceness1039843niceness
nicest82315663nicest_
nicety1138433nice_ty
nocent83217413nocent_
nonets64118703_nonets
ointments1166653ointments
oncet74626543once_t_
onsets64013543onse_ts
orients7311583orients
parents93418123parents
patents94815203patents
pendents1139413pendents
percents122713373percents
pigments1337343pigments
pincers113916503pince_rs
pinenes93416673pin_enes
pinkens13419643pinken_s
precents123015043precents
pschents1544113pschents
recants93217093recants
recent83630853recent_
recepts113010263recepts
regents83416543regents
reinvents1246123reinvents
relents74018503relents
rents55935183__rents
repents93717623repents
rerents73319423rerents
resents74221223resents
ringent8315153ringent_
rodents8611543rodents
scants85219723_scants
scenas84114703_scenas
scends95213003_scends
scenes84520353_scenes
scent75831623_scent_
secants93413893secants
silents73514493silents
sklents11348163sklents
splents93912133splents
stents65019453_stents
talents7312013talents
tangents938713tangents
tents56434213__tents
tincts84510803tinc__ts
unbelts9237663unbelts
unbends10236993unbends
unbent83216593unbent_
uncinus937403uncinus
unguents945153unguents
unkent103116053unkent_
unpens82511013unpen_s
unpent83117373unpent_
unrent63219783unrent_
unrests7229463unrests
unseats73012853unseats
unsent63820963unsent_
unsets64116163unse_ts
vents86125933__vents
wincers123415363wince_rs
winces114819113wince__s
winceys15395523wince_ys
wisents10249063wisents

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.403443402.0
2DLD Change Limit1340273196.92319359.7
3Display Results3193190.1262531.7
 (SQL Overall)1786913197.45223978.9
 
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.