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

381 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
ignites8131058(None) 
ignite71410581ignite_
ignited9137621ignited
igniter8147671igniter
igniters9126231igniters
lignites9129611lignites
agnates82813192agnates
agnizes17328842agnizes
dignities1149592dignities
dunites8313592dunites
finites10315922finites
gites65630182_g_ites
gunites8313122gunites
ichnites1345742ichnites
ignifies1277562ignifies
ignitor8125262ignitor
ignitors9135512ignitors
ignores8269002ignores
illites72415012illites
incites93218482incites
indites83618982indites
ingates82716912ingates
invites103915812invites
iolites73819482iolites
ionises72916432ionises
ionizes162813342ionizes
lenites7818442lenites
lignite81310302lignite_
nites55736342__nites
pinites9319532pinites
reignites1046932reignites
sienites8311912sienites
unites65024852_unites
aconites10314353aconites
agates76121343ag_ates
agenizes18269743agenizes
aggies83515513aggi_es
agitas7310593ag_itas
agnate73314883agnate_
agnize16329563agnize_
agnized18247223agnized
agonies83016623agoni_es
agonises92613163agonises
agonistes10266263agonistes
agonizes182610583agonizes
albites9313203albites
alunites8310703alunites
amniotes1036603amniotes
animes84719593_animes
anises64826693_anises
annates72415423annates
antes56334323_an_tes
aplites9314933aplites
arenites8917103arenites
ascites9312603ascites
augites8312183augites
aunties73920073aunties
axites134913833_axites
banties94324763banties
barites94322333barites
biggies113813523biggi_es
binits85716673binit_s
biotites10310083biotites
bites75641173__bites
blites84721213_blites
boites84322703_boites
bonitas939453bonitas
bonitoes1038153bonitoes
bonitos939733bonitos
bornites10310983bornites
canines93724033canines
canities101519263canities
cenotes92814543cenotes
cerites94823433cerites
cites74435593__cites
cognates11311583cognates
cognises11610043cognises
cognizes2058033cognizes
conies84338593coni_es
conines93827793conines
contes84432913con_tes
crinites10612763crinites
curites93919863curites
cyanites132610163cyanites
dacites101114593dacites
denies74729643deni_es
denotes83817003denotes
digits84114533dig_it_s
dignifies1446363dignifies
dignity1236453dignit_y
dingies93618243dingi_es
diorites9313523diorites
disunites1088673disunites
dites66339153__dites
donates83217223donates
dunite7315013dunite_
dunnites947173dunnites
ebonites1039233ebonites
egalites9310503egalites
egises7312493eg_ises
eighties12710803eighties
elites66027123_elites
enates64026433_enates
endites83717063endites
engines81114463engines
equites162212493equites
evites94916473_evites
excites16310633excites
finises10312903finises
finite9316823finite_
flites95122443_flites
fomites123613203fomites
frites94922483_frites
gahnites1235703gahnites
gaited84416923_gaited
gaiter73819503_gaiter
gaiters83516543_gaiters
gaits65726013_gait_s
gates65939513_g_ates
gelignites1243583gelignites
genies75324943geni_es
gentes75324163_gentes
gestes75721393_gestes
gibes84422523_g_ibes
gies55641423_g_i_es
ginzoes1735433ginzoes
gite55438613_g_ite_
gits55744593_g_it_s
gives95324873_g_ives
glides84518863_glides
glimes94717523_glimes
glitzes17367563_glitzes
glutes74517673_glutes
gnats65217713_gnat_s
gnomes93812973_gnomes
gnoses76515163_gnoses
goiter74116203_goiter
goiters84014443_goiters
goitres8389563_goitres
granites92116363granites
grates75429893_grates
grides84422363_grides
grimes94619033_grimes
gripes94619873_gripes
griths105211653_griths
grits65529583_grit_s
guides84118283_guides
guiles73919283_guiles
guises74216313_guises
gunite7414403gunite_
halites103221193halites
hinnies103615103hinni_es
ibices10398163i_bices
ibises83610543i_bises
ichnite1245983ichnite_
ideates8313733ideates
ignatia846133ignatia
ignatias944913ignatias
igneous835773igneous
ignified1386213ignified
ignify1334513igni_fy
igniting1037363igniting
ignition946533ignition
ignitions1045803ignitions
ignitron943203ignitron
ignitrons1042993ignitrons
ignore7269063ignore_
ignored9226443ignored
ignorer8276103ignorer
ignorers9215243ignorers
ileitis738063ileitis
illite63414923illite_
ilmenites1146103ilmenites
imbibes1334693imbibes
imides94515343i_mides
imines84918353i_mines
immies102412443immi_es
immixes1835073immixes
imputes1138083imputes
inanes62519803i_nanes
inanities9312443inanities
inches114419673i_nches
incises93414893incises
incite83618733incite_
incited103314623incited
inciter93113773inciter
inciters103210673inciters
indices103513443indices
indies73822783i_ndies
indite73520323indite_
indited93515023indited
inditer83514233inditer
inditers93311053inditers
indues73515263i_ndues
infinites1258693infinites
infixes17238133infixes
ingate73018243ingate_
ingles74420873i_ngles
ingoted939183ingoted
ingots7912063ingot_s
ingrates9514173ingrates
inions64417003i_nions
inkles103515653i_nkles
inlets63915573i_nlets
inmates92715783inmates
innages82911303innages
innate63917313innate_
innings8329443innings
inosites8312793inosites
insets64016133i_nsets
insides8512653insides
instep838193i_nstep
insteps936573i_nsteps
inter55028493i_n_ter
inters64328053i_n_ters
intines7921113intines
intis55121643i_n_tis
intitles8710003intitles
inures63318953i_nures
invite93715033invite_
invited113612463invited
invitee103713543invitee
invitees11377903invitees
inviter104112313inviter
inviters11359643inviters
iodates8312903iodates
iodides93811613iodides
iodines83616633iodines
iodises83413633iodises
iodizes173911723iodizes
iolite63221983iolite_
ionics84214483ioni_cs
ionise63516943ionise_
ionised82911493ionised
ioniums938303ioniums
ionize154613873ionize_
ionized172611293ionized
ionizer162310123ionizer
ionizers17257713ionizers
ionones7313883ionones
irides74519123i_rides
irises64221173i_rises
iritis63113733i_ritis
ironies7517423ironi_es
ironizes17510373ironizes
ivies84215763i_vi_es
kainites1238793kainites
kentes105118653ken_tes
kernites1269113kernites
kites95432543__kites
knifes136210213_knifes
knits93914743_knit_s
knives13458553_knives
kunzites2143243kunzites
kyanites15216683kyanites
lenite6719983lenite_
lenited8812433lenited
lenities8315943lenities
ligates82318383lig_ates
lignifies1346263lignifies
lignins84010493ligni_ns
lignitic1146393lignitic
limites92915453limites
limonites1148003limonites
lionises8310313lionises
lionizes1738773lionizes
lucites9311863lucites
lunies64723013luni_es
magnates11511613magnates
manitos9314053manitos
manitus9310923manitus
mannites10312613mannites
mantes84430783man_tes
migrates111112853migrates
minnies93617363minni_es
minutes93513443minutes
miscites12313783miscites
mites75141803__mites
monies83233163moni_es
montes84226933mon_tes
nates55238333__nates
nides65229133__nides
nighties121011383nighties
nines55937343__nines
ninnies73713613ninni_es
niobites1037313niobites
nite45943583__nite_
niter55028973__niter
niters64624213__niters
nitres65519333__nitres
nitrites82313453nitrites
nits45741643__nit_s
nixes124519623__nixes
norites74018803norites
notes55034583__notes
ogives10367913og_ives
oolites72817843oolites
ophites12310103ophites
ornithes1136423ornithes
panties94230933panties
pelites93821993pelites
penates93321603penates
penises9318193penises
penlites10312273penlites
petites93820203petites
picrites121811083picrites
pigeonites1343903pigeonites
piggies113813483piggi_es
pigmies122610993pigmi_es
pignuts1035613pignut_s
pigsties1139783pigsties
pinite8321243pinite_
pinnies93318443pinni_es
podites103014733podites
pointes93216753pointes
ponies84833463poni_es
pontes83627853pon_tes
punties94520783punties
pyrites12812203pyrites
quintes164114713quintes
ratites74920683ratites
recites93524583recites
reignite947233reignite_
reignited1145683reignited
rentes65431193ren_tes
resites74027793resites
reunites8312473reunites
righties12711573righties
rites54442553__rites
samites93118713samites
sanies63031953sani_es
sanities81219773sanities
senates73322613senates
seniles72618023seniles
sienite7312713sienite_
signages1037483signages
signees83510803sign_ees
signeted1035973signeted
signets83311503signet_s
signifies1347063signifies
signiors944923signiors
sites56045433__sites
skites104418043_skites
smites83921923_smites
snipes83917393_snipes
snits54124833_snit_s
somites94219123somites
sopites93817173sopites
sorites73825243sorites
spites84127333_spites
sprites94220333sprites
stibnites1144043stibnites
suites63727403_suites
syenites1138943syenites
taxites1449673taxites
tillites8312833tillites
tinnitus843783tinnitus
titanites997413titanites
uglies7412323ugli_es
unite54828383_unite_
united74421543_united
uniter64619143_uniter
uniters73814173_uniters
unities72520153_unities
units54923433_unit_s
unties64326923_unties
uranites82514643uranites
vanities111414493vanities
velites103417303velites
venines103516613venines
venires103012453venires
verites103822263verites
vignettes1344673vignettes
whites123919883_whites
wienies102213683wieni_es
wites85536963__wites
writes94420333_writes
yentes95517603yen_tes
zanies153219673zani_es
zeniths1935153zeniths
zincites1946633zincites

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.406440125.6
2DLD Change Limit1340273816.44020811.6
3Display Results3813810.1402721.4
 (SQL Overall)1786913816.98625578.4
 
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.