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

268 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
ignited913762(None) 
ignite71410581ignite_
igniter8147671igniter
ignites81310581ignites
agnized18247222agnized
gaited84416922_gaited
ignified1386212ignified
igniters9126232igniters
ignitor8125262ignitor
ignored9226442ignored
incited103314622incited
indited93515022indited
ingoted939182ingoted
invited113612462invited
ionised82911492ionised
ionized172611292ionized
lenited8812432lenited
lignite81310302lignite_
lignites9129612lignites
reignited1145682reignited
signeted1035972signeted
united74421542_united
agenized19257733agenized
agented939423agented
agisted938203agisted
agnate73314883agnate_
agnates82813193agnates
agnize16329563agnize_
agnizes17328843agnizes
agonised10248483agonised
agonized19258993agonized
anted66328243_an_ted
audited939033audited
awaited1146963awaited
baited95319243_baited
bighted142810923big_hted
bigoted11258403big_oted
bruited104110353bruited
bunted95219183bun_ted
canted94825783can_ted
cited84421953__cited
cognised1256313cognised
cognized2136293cognized
debited113311623debited
denied84318633deni_ed
denimed1159233denimed
denoted93512763denoted
dented84120513den_ted
digested11208163digested
dighted132511493dig_hted
dignified1545573dignified
dignities1149593dignities
dignity1236453dignit_y
dinted84419843din_ted
disunited1177273disunited
doited85016633_doited
donated93513863donated
dunite7315013dunite_
dunites8313593dunites
dunted84718503dun_ted
edited83913673_edited
egested938123egested
endited93512913endited
engined9119893engined
evited104013143_evited
excited1737853excited
exited144712523_exited
fainted114211723fainted
feinted11379623feinted
finite9316823finite_
finites10315923finites
flinted114411893flinted
flited104616583_flited
fruited11389093fruited
gained84617463_gained
gaiter73819503_gaiter
gasted84821583_gasted
gated75329773_g_ated
gibed96215963_g_ibed
gied64631983_g_i_ed
gifted114510703_gifted
ginned83813983gin_ned
girted83912873_girted
gite55438613_g_ite_
gites65630183_g_ites
gitted84015053_gitted
glided94513903_glided
glimed105312283_glimed
glinted9399373_glinted
glitzed18375493_glitzed
gnawed11427833_gnawed
goiter74116203_goiter
grated84523923_grated
grided95117043_grided
grifted12379583_grifted
grimed104714093_grimed
griped104114713_griped
gritted94110903_gritted
guided94014113_guided
guiled84315383_guiled
guised84612173_guised
gunite7414403gunite_
gunites8313123gunites
gusted84316723_gusted
gutted84716363_gutted
habited1337883habited
hanted104124313han_ted
hented104218753hen_ted
highted152710163hig_hted
hinnied11348103hinni_ed
hinted104318323hin_ted
honied104818393honi_ed
hunted104417013hun_ted
ichnite1245983ichnite_
ichnites1345743ichnites
ideated9310973ideated
igged86012763ig__ged
ignatia846133ignatia
ignifies1277563ignifies
ignify1334513igni_fy
igniting1037363igniting
ignition946533ignition
ignitors9135513ignitors
ignitron943203ignitron
ignore7269063ignore_
ignorer8276103ignorer
ignores8269003ignores
illite63414923illite_
illites72415013illites
imbibed1433733imbibed
immixed1933573immixed
imputed1236533imputed
inbred93010403i_nbred
inched124514483i_nched
incised102911583incised
incite83618733incite_
inciter93113773inciter
incites93218483incites
indeed83913563i_ndeed
indicted1249203indicted
indite73520323indite_
inditer83514233inditer
indites83618983indites
indued83411653i_ndued
inedited10278993inedited
infixed18206563infixed
ingate73018243ingate_
ingates82716913ingates
ingested10259003ingested
inked104218523i_n_ked
innate63917313innate_
inned64118423i_n_ned
insisted998673insisted
instead836203i_nstead
instep838193i_nstep
intend72310373i_n_tend
inter55028493i_n_ter
intitled967343intitled
intuited938763intuited
inured73114813i_nured
invite93715033invite_
invitee103713543invitee
inviter104112313inviter
invites103915813invites
iodated9310023iodated
iodised9329243iodised
iodized18969163iodized
iolite63221983iolite_
iolites73819483iolites
ionise63516943ionise_
ionises72916433ionises
ionize154613873ionize_
ionizer162310123ionizer
ionizes162813343ionizes
irised73913153i_rised
ironized1858203ironized
isleted837523isleted
ivied94710523i_vi_ed
jointed15378503jointed
kited105120093__kited
knifed14528123_knifed
knitted12337423_knitted
lanated8313203lanated
lenite6719983lenite_
lenites7818443lenites
ligated92414143lig_ated
lighted122913503lig_hted
lignified1445063lignified
lignitic1146393lignitic
limited102310233limited
linted74021823lin_ted
lionised946603lionised
lionized1837023lionized
lunated8310823lunated
lunted74517523lun_ted
merited10313853merited
migrated121110513migrated
minted94220583min_ted
minuted10329503minuted
miscited13310423miscited
monied94319463moni_ed
nided75920873__nided
nite45943583__nite_
niter55028973__niter
nites55736343__nites
nitid61817833__nitid
nixed135714223__nixed
noted65123843__noted
orbited1037733orbited
painted104214633painted
panted95024823pan_ted
pinite8321243pinite_
pinites9319533pinites
pinnated11338553pinnated
pinniped1343853pinniped
plaited103713893plaited
pointed103813983pointed
ponied94920703poni_ed
posited10511493posited
printed104016373printed
punted94618713pun_ted
quoited1756403quoited
ranted74324703ran_ted
recited104319103recited
reignite947233reignite_
reignites1046933reignites
rented74426593ren_ted
resited85122423resited
reunited939713reunited
righted122912143rig_hted
sainted84114243sainted
sienite7312713sienite_
sienites8311913sienites
sighted123111523sig_hted
signaled1035393signaled
signed83413753sign__ed
signified1446043signified
sited65130743__sited
skited114313483_skited
sniped94913483_sniped
sopited104211063sopited
spited94820443_spited
stinted82914193stinted
suited74019423_suited
tainted83512423tainted
tented74221003ten_ted
tincted1037273tincted
tinted74419533tin_ted
toited74016753_toited
ungated92717213ungated
ungifted13116833ungifted
unite54828383_unite_
uniter64619143_uniter
unites65024853_unites
unnoted8311363unnoted
untied73720813_untied
ununited938683ununited
vanitied12138213vanitied
vented104617923ven_ted
vignetted1443493vignetted
visited1168773visited
vomited1337253vomited
waited103819773_waited
wanted104319723wan_ted
whited134814083_whited
wited94727143__wited
wonted103213283won_ted
zonated173310533zonated

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 Limit1340272685.93622578.7
3Display Results2682680.0962791.7
 (SQL Overall)1786912686.45227695.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.