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

276 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
igniter814767(None) 
ignite71410581ignite_
ignited9137621ignited
igniters9126231igniters
ignites81310581ignites
ignitor8125261ignitor
gaiter73819502_gaiter
goiter74116202_goiter
ignitors9135512ignitors
ignorer8276102ignorer
inciter93113772inciter
inditer83514232inditer
inter55028492i_n_ter
inviter104112312inviter
ionizer162310122ionizer
lignite81310302lignite_
lignites9129612lignites
niter55028972__niter
uniter64619142_uniter
aginner844663aginner
aglitter935093aglitter
agnate73314883agnate_
agnates82813193agnates
agnize16329563agnize_
agnized18247223agnized
agnizes17328843agnizes
arbiter939933arbiter
awaiter1057443awaiter
baiter84422553_baiter
banister10199973banister
banter84825333ban_ter
biter75030033__biter
bonier84321993boni_er
bruiter93710633bruiter
bunter85020383bun_ter
canister101710853canister
canter85230113can_ter
center84421413cen_ter
citer74827333__citer
cognizer2055863cognizer
cointer93616723cointer
conifer123212643conifer
denier74420693deni_er
digester10258433digester
dignitary1442463dignitary
dignities1149593dignities
dignity1236453dignit_y
dingier93513673dingi_er
disinter9310673disinter
disuniter1086203disuniter
dunite7315013dunite_
dunites8313593dunites
enter54726383_en_ter
exciter1637753exciter
fainter103611053fainter
figeater1236953figeater
fighter143010773fig_hter
finite9316823finite_
finites10315923finites
finnier10319953finni_er
fruiter10309683fruiter
gainer74117493_gainer
gaited84416923_gaited
gaiters83516543_gaiters
ganister9178993ganister
garter74420513_garter
gaster75027353_gaster
gater64533653_g_ater
genitor837273genitor
getter74117613_getter
giber85417703_g_iber
ginger84920033gin_ger
ginner73915823gin_ner
ginnier8298983ginnier
gite55438613_g_ite_
gites65630183_g_ites
giver94921203_g_iver
glider84614263_glider
glister84013343_glister
glitter84211803_glitter
gnawer10386953_gnawer
goiters84014443_goiters
goitre7349003_goitre
grater74625443_grater
grifter113810493_grifter
griper94114613_griper
grister83915413_grister
gritter83913353_gritter
guider84313523_guider
guitar7117443_guitar
gunite7414403gunite_
gunites8313123gunites
gutter73817713_gutter
hinter94021303hin_ter
hunter94817773hun_ter
ichnite1245983ichnite_
ichnites1345743ichnites
icier74313753i_ci_er
ickier12439923icki_er
iffier1236763iffi_er
ignatia846133ignatia
ignified1386213ignified
ignifies1277563ignifies
ignify1334513igni_fy
igniting1037363igniting
ignition946533ignition
ignitron943203ignitron
ignore7269063ignore_
ignored9226443ignored
ignorers9215243ignorers
ignores8269003ignores
illite63414923illite_
illites72415013illites
imbiber1333593imbiber
imbitter12265283imbitter
imputer1136533imputer
inaner62213543i_naner
incher114114033i_ncher
incite83618733incite_
incited103314623incited
inciters103210673inciters
incites93218483incites
indicter1148143indicter
indite73520323indite_
indited93515023indited
inditers93311053inditers
indites83618983indites
infer84215033i_n_fer
ingate73018243ingate_
ingates82716913ingates
ingather1244783ingather
ingoted939183ingoted
inker94421093i_n_ker
inkier104013783i_nkier
inlier63615363i_nlier
innate63917313innate_
inner54920633i_n_ner
insider849733insider
insister888783insister
instar6310013i_nstar
instep838193i_nstep
intern64016543i_n_tern
inters64328053i_n_ters
invite93715033invite_
invited113612463invited
invitee103713543invitee
inviters11359643inviters
invites103915813invites
iodizer17408663iodizer
iolite63221983iolite_
iolites73819483iolites
ionise63516943ionise_
ionised82911493ionised
ionises72916433ionises
ionize154613873ionize_
ionized172611293ionized
ionizers17257713ionizers
ionizes162813343ionizes
ionomer939833ionomer
irater65218353i_rater
janitor1436483janitor
jiggier16377823jiggi_er
jointer14379713jointer
juniper1634023juniper
kiter95523213__kiter
knifer13598563_knifer
knitter11348133_knitter
lenite6719983lenite_
lenited8812433lenited
lenites7818443lenites
lighter113113443lig_hter
lignitic1146393lignitic
limiter92710853limiter
lingier84113383lingi_er
linier64423793lini_er
linter64625343lin_ter
lintier73613803lintier
lioniser845583lioniser
lionizer1756053lionizer
liter54736343__liter
loiter64619173_loiter
lunier64617603luni_er
mightier1436383mightier
mingier103815293mingi_er
minister10410363minister
miniver1238393miniver
minster93914323minster
minter84425103min_ter
mintier93615993mintier
minuter93510413minuter
misinter1038833misinter
miter75734793__miter
moniker1338673moniker
monitor9310723monitor
monster93214603monster
munster93710523munster
nicer74618293__nicer
nite45943583__nite_
niters64624213__niters
nitery94412173__nitery
nites55736343__nites
nitre57519683__nitre
noter55025643__noter
orbiter937853orbiter
painter93814563painter
panier84425503pani_er
penster92811953penster
piggier113510003piggi_er
pinier84024693pini_er
pinite8321243pinite_
pinites9319533pinites
plaiter93615393plaiter
pointer93814933pointer
politer92417073politer
printer93917303printer
punier84519223puni_er
punster92911103punster
punter84320023pun_ter
ranter63826823ran_ter
reciter94117263reciter
reignite947233reignite_
reignited1145683reignited
reignites1046933reignites
reinter73116843reinter
renter64527413ren_ter
rentier73618223rentier
reuniter838323reuniter
righter113212383rig_hter
runtier73512853runtier
sienite7312713sienite_
sienites8311913sienites
sighter113412113sig_hter
signaler945453signaler
signer74015633sign__er
signeted1035973signeted
signifier1345713signifier
signior835043signi_or
sinister838583sinister
sinter63625923sin_ter
smiter83616413_smiter
snider74413913_snider
snifter10349623_snifter
sniper84413643_sniper
stinter73614513stinter
suiter64121813_suiter
tenter64623933ten_ter
tentier73815923tentier
tighter112910693tig_hter
tinier63622233tini_er
tinnier72910143tinni_er
tinter63923643tin_ter
titer55430613__titer
tonier65520713toni_er
triter65120593_triter
uglier748953ugli_er
unite54828383_unite_
united74421543_united
uniters73814173_uniters
unites65024853_unites
unmiter9310393unmiter
venter94218723ven_ter
vignetter1343323vignetter
vinier93716743vini_er
visiter1038863visiter
vomiter1237953vomiter
waiter94321253_waiter
wanier93920683wani_er
wanter94423053wan_ter
whiter124316393_whiter
wiggier12418863wiggi_er
wingier113413283wingi_er
winier94522453wini_er
winter94222803win_ter
writer94416513_writer
zanier154314713zani_er
zingier17369493zingi_er

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.406440125.6
2DLD Change Limit1340272765.86022871.5
3Display Results2762760.1102509.1
 (SQL Overall)1786912766.37628025.6
 
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.