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

365 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
ignite7141058(None) 
ignited9137621ignited
igniter8147671igniter
ignites81310581ignites
lignite81310301lignite
agnate73314882agnate
agnize16329562agnize
dignity1236462dignity
dunite7315012dunite
finite9316822finite
gite55438612_g_ite
gunite7414402gunite
ichnite1245982ichnite
ignify1334512ignify
igniters9126232igniters
ignitor8125262ignitor
ignore7269062ignore
illite63414922illite
incite83618732incite
indite73520322indite
ingate73018242ingate
innate63917312innate
invite93715032invite
iolite63221982iolite
ionise63516942ionise
ionize154613872ionize
lenite6719982lenite
lignites9129612lignites
nite45943582__nite
pinite8321242pinite
reignite947232reignite
sienite7312712sienite
unite54828382_unite
aconite9315473aconite
adnate72913483adnate
agate66525153ag_ate
agenize172910153agenize
aggie73415013aggi_e
agile65122263ag_ile
agita6315423ag_ita
agnates82813193agnates
agnized18247223agnized
agnizes17328843agnizes
agonise83112693agonise
agonize172911403agonize
albite8313313albite
alunite7311633alunite
amniote936963amniote
anile54634463_anile
anime75423203_anime
anise55129703_anise
ante46538903_an_te
aplite8316393aplite
arenite71017713arenite
augite7312613augite
auntie64317703auntie
axite125218253_axite
barite84224813barite
biggie103810933biggi_e
biggity1435013biggity
bigtime1235753bigtime
binate8419773binate
binit76431583binit_
binits85716673binits
biotite9311033biotite
bite66547003__bite
blite76225353_blite
boite74426323_boite
bonita8312943bonita
bonito8313433bonito
bornite9311183bornite
canine83826703canine
cenote83715843cenote
cerite84724873cerite
cite65640343__cite
cognate10312203cognate
cognise1059683cognise
cognize1957683cognize
conine84528553conine
conte76633203con_te
crinite9513633crinite
curite85222943curite
cyanite122710763cyanite
dacite91115883dacite
denote74118043denote
digit73825273dig_it_
digits84114533dig_its
dignify1543893dignify
dignities1149593dignities
diorite8314913diorite
disunite999313disunite
dite55547553__dite
donate73619503donate
dunites8313593dunites
dunnite857333dunnite
ebonite9310293ebonite
egalite8311563egalite
elite56230183_elite
enate54428153_enate
endite73817593endite
engine71114863engine
evite85317683_evite
excite15310883excite
finites10315923finites
finito9310303finito
flite85424963_flite
fomite113314073fomite
gahnite1135973gahnite
gait56150193_gait_
gaited84416923_gaited
gaiter73819503_gaiter
gaits65726013_gaits
gate55746573_g_ate
gelignite1143993gelignite
genie66124923geni_e
geste65920693_geste
gibe75927783_g_ibe
gie47149543_g_i_e
git46266053_g_it_
gites65630183_g_ites
gits55744593_g_its
give85829353_g_ive
glide74521593_glide
glime85620193_glime
glitz154916373_glitz
glute66020903_glute
gnat56034433_gnat_
gnats65217713_gnats
gnome84213953_gnome
goiter74116203_goiter
goitre7349003_goitre
granite82017083granite
grate64932883_grate
gride75223583_gride
grime85021323_grime
gripe84622963_gripe
grit55247243_grit_
grith95520373_grith
grits65529583_grits
guide75019883_guide
guile64521133_guile
guise64717713_guise
gunites8313123gunites
gwine95513663_gwine
halite93624233halite
ichnites1345743ichnites
ideate7313683ideate
igging93212073igging
ignatia846133ignatia
ignified1386213ignified
ignifies1277563ignifies
ignitable1245463ignitable
ignitible1243163ignitible
igniting1037363igniting
ignition946533ignition
ignitors9135513ignitors
ignitron943203ignitron
ignoble1043613ignoble
ignored9226443ignored
ignorer8276103ignorer
ignores8269003ignores
illites72415013illites
ilmenite1046223ilmenite
imbibe1234703imbibe
imide85716893i_mide
imine75821063i_mine
impute1038043impute
inane52820343i_nane
inanity1039503inanity
inbye10427063i_nbye
incise83515333incise
incited103314623incited
inciter93113773inciter
incites93218483incites
indie63721473i_ndie
indited93515023indited
inditer83514233inditer
indites83618983indites
indue63516673i_ndue
infinite1149603infinite
ingates82716913ingates
ingle64120433i_ngle
ingot61221063ingot_
ingoted939183ingoted
ingots7912063ingots
ingrate8715123ingrate
inia45024703i_ni_a
inion54620183i_nion
inkle94515833i_nkle
inlet53732403i_nlet
inmate82917363inmate
innage73011573innage
inning73617633inning
inosite7314063inosite
inset54430863i_nset
inside7613453inside
instep838193i_nstep
inter55028493i_n_ter
inti46626083i_n_ti
intime81014273intime
intine61021983intine
intis55121643i_ntis
intitle7610583intitle
into45026153i_n_to
inure54119053i_nure
invited113612463invited
invitee103713543invitee
inviter104112313inviter
invites103915813invites
iodate7313503iodate
iodide84812933iodide
iodine74618653iodine
iodise74214943iodise
iodize164112593iodize
iolites73819483iolites
ionic74622663ioni_c
ionics84214483ionics
ionised82911493ionised
ionises72916433ionises
ionium8610923ionium
ionized172611293ionized
ionizer162310123ionizer
ionizes162813343ionizes
ionone6313443ionone
irate55627983i_rate
ironize16610373ironize
jiglike19105333jiglike
kainite1149543kainite
kente95821073ken_te
kernite1159473kernite
kite85338243__kite
knife1210010133_knife
knit85728143_knit_
knits93914743_knits
kunzite2053503kunzite
kyanite14237313kyanite
lanate6421263lanate
lenited8812433lenited
lenites7818443lenites
lenity9612713lenity
ligate72519253lig_ate
lignify1443793lignify
lignin74911193ligni_n
lignins84010493lignins
lignitic1146393lignitic
limonite1048163limonite
lionise7310373lionise
lionize1668823lionize
lite47054543__lite
lucite8313343lucite
lunate6316043lunate
magnate10512703magnate
manito8518693manito
manitu8315823manitu
mannite9312903mannite
migrate101314173migrate
minute83414293minute
miscite11314383miscite
mite66249413__mite
monie75631653moni_e
monte75829773mon_te
nice65534713__nice
nide55535793__nide
nightie1179653nightie
nine45842173__nine
niobite937953niobite
nit37065943__nit_
niter55028973__niter
nites55736343__nites
nitre57519683__nitre
nitrite72314463nitrite
nits45741643__nits
nixe115722023__nixe
norite63221133norite
note46239963__note
ogive9379093og_ive
oolite63319603oolite
ophite11410563ophite
ornate6315143ornate
pantie84326473pantie
pelite84323003pelite
penile82219603penile
penlite9313243penlite
petite84320653petite
picrite111911313picrite
pigeonite1244183pigeonite
piggie103210773piggi_e
piglike14157313piglike
pignut9311573pignut_
pignuts1035613pignuts
pinites9319533pinites
pinnate93613743pinnate
podite93315353podite
pointe84619313pointe
polite83625073polite
pyrite11913313pyrite
quinte153414523quinte
quite144621463_quite
ratite65022423ratite
recite83625113recite
reignited1145683reignited
reignites1046933reignites
rente54733783ren_te
resite64128453resite
reunite7312713reunite
rite45849453__rite
samite83020603samite
sanity9316203sanity
senate63725173senate
senile63420213senile
seniti64317223seniti
sente56432883sen_te
sienites8311913sienites
sigmate10710143sigmate
signage937773signage
signee73617233sign_ee
signet73621153signet_
signeted1035973signeted
signets83311503signets
signify1444853signify
signing92713963signing
signior835043signior
signore8329093signore
site47052413__site
skite95120053_skite
smite75224873_smite
snide64318723_snide
snipe75320573_snipe
snit46342473_snit_
snits54124833_snits
somite84519373somite
sopite84917713sopite
spite75430663_spite
sprite84421773sprite
stibnite1044073stibnite
suite54829563_suite
syenite1039773syenite
taxite13511303taxite
teniae64517353teniae
tentie62521183tentie
tillite7313563tillite
titanite898433titanite
trite54730033_trite
unit45140073_unit_
united74421543_united
uniter64619143_uniter
unites65024853_unites
units54923433_units
unity84918493_unity
untie54425493_untie
uranite72515693uranite
vanity12311933vanity
venine93718433venine
venire93513693venire
verite94323443verite
vignette1245043vignette
white114920303_white
wienie9229973wieni_e
wiglike15125853wiglike
wite75443273__wite
write85522833_write
yente86220043yen_te
zenith1839073zenith
zincite1837233zincite
zonate154114923zonate

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163655.15621861.1
3Display Results3653650.1103318.2
 (SQL Overall)1786913655.65631593.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.