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

137 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
nonlives113836(None) 
connives1339722connives
lowlives1434572lowlives
nonlevel1144372nonlevel
nonlife1038552nonlife_
olives94313952_o_lives
unlives102010952_unlives
bolides10515073bo_lides
bollixes1747203bollixes
bonfires1367383bonfires
bowlines133211623bowlines
codrives1437663codrives
colies84837053co_li_es
collides113214473collides
collies94326583colli_es
concaves1538913concaves
conceives1639233conceives
conclaves1646543conclaves
confides14310573confides
confines13315653confines
conies84338593con_i_es
coniines10415363coniines
conines93827793con_ines
connive1238993connive_
connived1436433connived
conniver1337493conniver
connivers1436933connivers
contrives14311703contrives
coolies93824963cooli_es
doilies84017363doili_es
dollies83620983dolli_es
donatives13146903donatives
doolies83920713dooli_es
doylies114512573doyli_es
endives113710693_endives
enliven1034903_enliven
enlivens1144043_enlivens
folklives1942673folklives
follies103618943folli_es
forgives1535753forgives
goalies8316023goali_es
holies94630033ho_li_es
hollies103420813holli_es
hongies112716473hongi_es
honkies143015143honki_es
hoplites13310543hoplites
hotlines11811643hotlines
iolites73819483io_lites
ionises72916433ion_ises
ionizes162813343ion_izes
jollies143516273jolli_es
knives13458553_kn_ives
lives86133193___lives
lollies73116923lolli_es
longies82916553longi_es
longlines1047983longlines
lowlifes1434333lowlifes
midlives14287463midlives
mislives132912153mislives
molies84429513mo_li_es
mollies93420233molli_es
monies83233163mon_i_es
motives123611893mo_tives
naives94914223__naives
nancies93516843nanci_es
nannies73015203nanni_es
natives10310823n_atives
negliges1034833negliges
nellies73418723nelli_es
ninnies73713613ninni_es
nobles83319723nobl__es
noddies93512043noddi_es
noesises838503noesises
noises65021853no__ises
nonages8313843non_ages
nonces84418833non__ces
noncrimes13126923noncrimes
noncrises11129313noncrises
nondriver1344863nondriver
nondrivers1444263nondrivers
nonelite8313613nonelite_
nones55639133non___es
nonglares1046413nonglares
nonlineal946163nonlineal
nonlinear944823nonlinear
nonliving1346763nonliving
nonlivings1443093nonlivings
nonnatives1345643nonnatives
nonnovel1144413nonnovel
nonnovels1243443nonnovels
nonpluses1145713nonpluses
nonrival1146623nonrival
nonrivals1244533nonrivals
nonselves1246503nonselves
nontaxes1537853nontaxes
nonuples1056533nonuples
nonuses73313863non_uses
nonwhites1545393nonwhites
nonwoven1444633nonwoven
nonwovens1543793nonwovens
noogies82814583noogi_es
nookies113414963nooki_es
noontides1075123noontides
noontimes1164513noontimes
norites74018803no_rites
nosedives1343713nosedives
notices9312283no_tices
novelises1247373novelises
novelizes2146223novelizes
novices1238223no_vices
nuclides1146553nuclides
nunlike11258073nunlike_
obliges1037143_obliges
ogives10367913_o_gives
olive84817153_o_live_
online6315843_online_
oolites72817843_oolites
outlives112511763outlives
penlites10312273penlites
polices113118053po_lices
polies84034583po_li_es
pollices12410753pollices
ponies84833463pon_i_es
potlines10714213potlines
prelives13310383prelives
relives104619443_relives
solves95018223so_l_ves
sonlike112110713sonlike_
sonnies7315223sonni_es
tontines82114733tontines
toplines102412563toplines
towlines112610343towlines
unlive92712333_unlive_
unlived112511373_unlived
votives13337953vo_tives
wolves124510853wo_l_ves
woolies104117363wooli_es

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621376.42322756.0
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.87226002.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.