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

148 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
ignoring103648(None) 
goring84119572_g_oring
honoring12310472honoring
igniting1037362igniting
ignominy1443562ignominy
ignorant947152ignorant
ingoing9311022ingo_ing
ingoting1039862ingoting
inuring81213012i_nuring
minoring11311472minoring
signorina1043962signorina
signorine1045172signorine
snoring83917202_snoring
adoring9412523_adoring
agnizing1936833agnizing
agnomina1144263agnomina
angering102113803angering
annoying1246543annoying
armoring1149123armoring
boring94724873__boring
canoeing11310213canoeing
censoring1238783censoring
centring112112953centring
choring133617663_choring
coloring11414843coloring
coring94433963__coring
denoting10311753denoting
diagnosing1343713diagnosing
encoring11312173encoring
engorging1244873engorging
enuring8813883_enuring
favoring1596673favoring
figuring1336283fig_uring
fingering1439193fingering
flooring12259883flooring
gaoling93314653_gaoling
garring93116713_garring
gearing92818843_gearing
gingering1238873gingering
ginning93313983gin_ning
glaring93714883_glaring
globing113210003_globing
glorying1335543_glorying
gloving12308443_gloving
glowing123211793_glowing
glozing18338893_glozing
gnarling10217603_gnarling
gnarring10225973_gnarring
gnawing12377903_gnawing
going75218493_g_o_ing
gonging103713033_gonging
goofing123510633_goofing
goosing93314083_goosing
gorging102611363_g_orging
gorming112810833_g_orming
groping113313103_groping
growing123512473_growing
gyring113910363_g_yring
honouring1336883honouring
humoring1456853humoring
igging93212073ig__ging
ignifying1744313ignifying
ignorami1142863ignorami
ignorance1244583ignorance
ignore7269063ignor__e
ignored9226443ignor_ed
ignorer8276103ignor_er
ignorers9215243ignorers
ignores8269003ignor_es
immuring1335533immuring
imploring1445573imploring
imponing1338773imponing
importing1438193importing
imposing1348463imposing
inarming1138343i_narming
inbeing1038333i_nbeing
inching134414323i_nching
incoming1349863incoming
indorsing1137143indorsing
indowing13198083indowing
induing91910943i_nduing
informing1537023informing
infringe1245083i_nfringe
ingrowing1445533ingrowing
inhering12913713inhering
injuring1637473injuring
inking115119053i_n_king
inkling122911303i_nkling
inlying1168153i_nlying
innerving1346503innerving
inning73617633i_n_ning
inosine7314283i_nosine
inpouring1236393inpouring
insnaring1046313insnaring
insuring9311153insuring
intoning9311123intoning
intorting10311413intorting
inurning937553i_nurning
invoking1635653invoking
ionising9310223ionising
ionizing1839503ionizing
iring66025423i___ring
ironing82414013i_roning
jiggering1934303jiggering
knowing15287683_knowing
laboring112110143laboring
lingering11310513lingering
liquoring1943703liquoring
majoring1836363majoring
manuring1139223manuring
mentoring1239543mentoring
mirroring1246193mirroring
mooring102514443_mooring
motoring11410953motoring
nosing73419843__nosing
noting74120153__noting
ongoing938793ongo_ing
poring94227273__poring
razoring1836443razoring
reboring11312783reboring
rumoring1136983rumoring
savoring1269483savoring
scoring103117213_scoring
shoring112820073_shoring
signaling1136563signaling
signeting1136223signeting
signing92713963sign__ing
signori8347893signori__
signories10107853signories
signorinas1152673signorinas
skioring13237223skioring
snaring83920953_snaring
snorting92613373_snorting
snowing113913453_snowing
soring74731883__soring
spooring113111463spooring
sporing104319413_sporing
storing83921123_storing
taboring113010193taboring
tenoning938893tenoning
tenuring938863tenuring
tutoring938433tutoring
vaporing1437653vaporing
venoming1436403venoming
visoring1238373visoring
vizoring2134573vizoring
whoring142910293_whoring
winnowing1643363winnowing

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621486.70321805.5
3Display Results1481480.0632349.2
 (SQL Overall)1786911487.20224811.3
 
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.