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

202 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
igniting103736(None) 
agnizing1936832agnizing
gaiting93716582_gaiting
ignifying1744312ignifying
ignition946532ignition
ignitions1045802ignitions
ignoring1036482ignoring
inciting11312532inciting
inditing10312112inditing
ingoting1039862ingoting
inviting1239732inviting
ionising9310222ionising
ionizing1839502ionizing
leniting9312352leniting
reigniting1246372reigniting
signeting1136222signeting
uniting8315822_uniting
agenizing2046333agenizing
agenting1039383agenting
agisting1038243agisting
agonising1146573agonising
agonizing2047143agonizing
anting75827023_an_ting
auditing1039033auditing
awaiting1238273awaiting
baiting103918883_baiting
bighting15269453big_hting
biting95321823__biting
bruiting11259973bruiting
bunting103718833bun_ting
canting104725903can_ting
citing94220183__citing
cognising1347043cognising
cognizing2247173cognizing
debiting122511203debiting
denoting10311753denoting
denting94422183den_ting
digesting12208673digesting
dighting142510843dig_hting
dignifying1944153dignifying
dignities1149593dignities
dinting93520553din_ting
disuniting1247403disuniting
donating10311803donating
dunting93418383dun_ting
editing9313133_editing
egesting1039013egesting
enditing10311073enditing
engining1039293engining
eviting11511373_eviting
exciting1838023exciting
exiting15311393_exiting
fainting123312163fainting
feinting123410833feinting
fighting162710083fig_hting
finiking16277073finiking
flinting123412343flinting
fliting113514613_fliting
fruiting12229063fruiting
gaining94015663_gaining
gasting95022763_gasting
gating84826953_g_ating
getting93316563_getting
gibing103712353_g_ibing
gieing83614853_g_ieing
gifting123810893_gifting
ginning93313983gin_ning
girting93113333_girting
gitting93215703_gitting
giving114313883_g_iving
gliding103911843_gliding
gliming113310133_gliming
glinting103210053_glinting
glitzing1934973_glitzing
gnawing12377903_gnawing
grating93923183_grating
griding103014973_griding
grifting13299263_grifting
griming113612493_griming
griping113012063_griping
gritting10309983_gritting
guiding102911843_guiding
guiling93214213_guiling
guising93511413_guising
gusting93917163_gusting
gutting93415923_gutting
habiting1437533habiting
hanting114124483han_ting
henting113719653hen_ting
highting16259723hig_hting
hinting113919223hin_ting
hunting114317123hun_ting
ideating10311703ideating
igging93212073ig__ging
ignatia846133ignati_a
ignatias944913ignatias
ignified1386213ignified
ignifies1277563ignifies
ignite71410583ignit__e
ignited9137623ignit_ed
igniter8147673ignit_er
igniters9126233igniters
ignites81310583ignit_es
ignitible1243163ignitible
ignitor8125263ignit_or
ignitors9135513ignitors
ignitron943203ignitron
ignitrons1042993ignitrons
ignominy1443563ignominy
imbibing1534043imbibing
immixing2043543immixing
imputing1336853imputing
inbeing1038333i_nbeing
inching134414323i_nching
incising11411093incising
indicting1339613indicting
induing91910943i_nduing
infixing1936103infixing
ingesting11129623ingesting
ingoing9311023i_ngoing
initial7311883i_nitial
inking115119053i_n_king
inkling122911303i_nkling
inlying1168153i_nlying
inning73617633i_n_ning
insisting1038823insisting
intine61021983i_n_tine
intitling1037213intitling
intuiting1089613intuiting
inuring81213013i_nuring
iodating1038823iodating
iodising1037563iodising
iodizing1936673iodizing
irising83614423i_rising
ironizing1947933ironizing
jointing16248613jointing
kiting114117093__kiting
knifing1536483_knifing
knitting13257023_knitting
ligating102212283lig_ating
lighting132811833lig_hting
lignifying1843523lignifying
lignitic1146393ligniti_c
limiting1138813limiting
linting83820983lin_ting
lionising1046463lionising
lionizing1947053lionizing
lunting83817743lun_ting
meriting11314683meriting
migrating13910533migrating
minting103020813min_ting
minuting1139723minuting
misciting1439673misciting
munting103718773mun_ting
niding83217983__niding
nixing143311493__nixing
nonbiting1247823nonbiting
noting74120153__noting
orbiting1138153orbiting
painting113614423painting
panting104025423pan_ting
plaiting113113513plaiting
pointing112813683pointing
positing11312303positing
printing113216083printing
punting103318443pun_ting
quoiting1836093quoiting
ranting84025413ran_ting
reciting113118073reciting
renting84026853ren_ting
resiting93521123resiting
reuniting10310693reuniting
righting132610853rig_hting
sainting93215733sainting
sighting133110863sig_hting
signaling1136563signaling
signifying1844413signifying
signing92713963sign__ing
siting74126623__siting
skiting123812503_skiting
smiting103014443_smiting
sniping103712053_sniping
sopiting11310763sopiting
spiting103917623_spiting
stinting93415743stinting
suiting83419003_suiting
tainting93613583tainting
tenting84621153ten_ting
tincting1148883tincting
tinting84620603tin_ting
toiting83217093_toiting
ungiving1346333ungiving
venting114218093ven_ting
vignetting1542823vignetting
visiting1238393visiting
vomiting1437733vomiting
waiting113618953_waiting
wanting114220173wan_ting
whiting143311303_whiting
witing103522823__witing
wonting113214103won_ting
writing113713893_writing

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 Limit1461622027.39319770.3
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.90522604.8
 
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.