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

115 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
nonending113800(None) 
contending1449122contending
nonbinding1444902nonbinding
nonbonding1445032nonbonding
noncoding1347672noncoding
nonfading1445872nonfading
nonreading1246882nonreading
unending10239942_unending
amending12308913_amending
appending1536283appending
ascending1336283ascending
attending11136373attending
bending114420893__bending
blending12249963_blending
bonding113318433bo__nding
bonneting1236173bonneting
bounding123012133bo_unding
coheading1636623coheading
coleading1338523coleading
commending1846633commending
conceding1559343conceding
condensing1447743condensing
confiding1638333confiding
conning103718763con_n_ing
consenting13313223consenting
contenting13313323contenting
convening15311203conven_ing
conventing16311543conventing
cozening20188323cozen_ing
defending15298353defending
depending14208783depending
donning93512763don_n_ing
dovening13238363doven_ing
dozening19236203dozen_ing
emending12298893_emending
ending83220253___ending
expending2045933expending
extending1835853extending
fending123717603__fending
fomenting1537233fomenting
fonding123815423fo__nding
forfending1844183forfending
founding133010793fo_unding
friending1495553friending
honeying1537673hone_ying
hounding132610053ho_unding
impending1535933impending
intending1139983intending
jonesing1636633jone_sing
kneading1436373_kneading
lending94118533__lending
mending114018683__mending
mounding123311263mo_unding
needing93214423__needing
nodding103811523no__dding
nonacting1238783nonacting
nonbanking1743733nonbanking
nonbearing1346453nonbearing
nonbeing1137053non_being
nonbetting1345843nonbetting
nonbiting1247823nonbiting
nonbreeding1553323nonbreeding
nonbuying1543953nonbuying
noncaking1646683noncaking
noncling11310763non_cling
noncoking1646813noncoking
nondemanding1752463nondemanding
nondrying1444683nondrying
nonearning1145183nonearning
nonentity1246713nonentity
nonflying1643673nonflying
nonhunting1444683nonhunting
nonjuring1756053nonjuring
nonliving1346763nonliving
nonloving1345413nonloving
nonmeeting1346073nonmeeting
nonmoving1545103nonmoving
nonpaying1545713nonpaying
nonruling1046433nonruling
nonusing939233non_using
nonvoting1346903nonvoting
nonwinning1443503nonwinning
nooning83014853no_on_ing
offending1744093offending
omening10310103_omen_ing
opening1039933_open_ing
pending114119773__pending
poinding122510003po_inding
ponding114317083po__nding
portending1446193portending
pounding123311473po_unding
propending1646143propending
protending1446813protending
relending112412023relending
remending132311313remending
rending93924263__rending
resending112313363resending
rounding102812283ro_unding
scending122610583_scending
sending94221373__sending
shending132511253_shending
snedding11246953_snedding
sonneting1037003sonneting
sounding102712873so_unding
spending122712433_spending
tending94419163__tending
tokening1336473token_ing
trending103012833_trending
unbending1337463unbending
upending12258133_upending
upsending1334903upsending
vending124015263__vending
wending123816843__wending
wonning113210793won_n_ing
wounding13249403wo_unding

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411156.98621277.0
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.46823927.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.