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 “nonlife” 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
nonlife103855(None) 
lowlife1335142lowlife
nonelite8313612nonelite
nonlives1138362nonlives
nunlike11258072nunlike
online6315842_online
sonlike112110712sonlike
antilife11410433antilife
bolide9515563bo_lide
bonfire1287063bonfire
bonnie85314853bonni_e
bowlike16349473bowlike
bowline123613113bowline
boxlike20267073boxlike
coalify1536683coalify
collide103214793collide
collie83621993colli_e
concise11314473concise
confide13310203confide
confine12315583confine
conifer123212643con_ifer
coniine9316803coniine
conine84528563con_ine
connive1238993connive
coolie83821603cooli_e
doglike13207453doglike
donsie7613643donsi_e
doolie73916833dooli_e
downlike1636183downlike
fanlike142610503fanlike
finlike14279063finlike
folklife1842963folklife
foxlike21226223foxlike
goalie7413163goali_e
godlike1387563godlike
gonglike1455423gonglike
gonif94320923gon_if_
goniff13408893gon_iff
gonifs104310133gon_ifs
henlike1448693henlike
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
honkie133011673honki_e
hoolie93217783hooli_e
hoplite12311073hoplite
hornlike1536503hornlike
hotline10712353hotline
iolite63221983io_lite
ionise63516943ion_ise
ionize154613873ion_ize
ironlike1235713ironlike
jollify2044263jollify
knife1210010143_kn_ife
knoblike1343163knoblike
knotlike1144003knotlike
life75433743___life
lionlike1234983lionlike
longline938763longline
lowlifer1443283lowlifer
lowlifes1434333lowlifes
manlike133012793manlike
midlife13248303midlife
moline84422043mo_line
mollie83517103molli_e
mollify1555503mollify
monie75631653mon_i_e
moonlike1476643moonlike
nannie63713223nanni_e
neglige934873neglige
nellie63614813nelli_e
netlike11308913netlike
niblike1336703niblike
noble74420993nobl__e
noise55723733no__ise
nonage7313683non_age
nonbelief1445623nonbelief
nonce75719823non__ce
noncling11310763noncling
noncore9411953noncore
noncrime12116603noncrime
none45743173non___e
nongame1038183nongame
nonglare946373nonglare
nonheme1247133nonheme
nonhome1248833nonhome
nonleafy1443083nonleafy
nonlevel1144373nonlevel
nonliable1147673nonliable
nonlineal946163nonlineal
nonlinear944823nonlinear
nonoily1049543nonoily
nonpolice1345663nonpolice
nonsaline948413nonsaline
nonslip946553nonsli_p
nontitle846943nontitle
nonuple946153nonuple
nonuse63212253non_use
nonwage1137163nonwage
nonwhite1445703nonwhite
noogie73612313noogi_e
nookie103712433nooki_e
nooklike1134873nooklike
noontide986133noontide
noontime1095383noontime
noplace1137393noplace
norite63221133no_rite
noselike12158573noselike
notice8313443no_tice
notify1236943no_tify
novalike1536223novalike
novelise1137953novelise
novelize2046843novelize
novice1138433no_vice
nowise9511073no_wise
nuclide1037173nuclide
nullify1334713nullify
nutlike113110113nutlike
oblige937653_oblige
olive84817153_o_live
onside7511803_onside
oolite63319603_oolite
oxlike17307473_oxlike
penlite9313243penlite
podlike14108553podlike
police102918563po_lice
polite83625073po_lite
pontifex2043253pontifex
pontiff1547903pontiff
pontine92419053pontine
potlike13910123potlike
potline91015233potline
prelife1279953prelife
rodlike1288263rodlike
snowlike1534973snowlike
songlike1336523songlike
sonsie6614863sonsi_e
sunlike112310573sunlike
tinlike11248803tinlike
toelike11149823toelike
tontine72316143tontine
topline92313183topline
towline102911543towline
toylike14157243toylike
unlike102614063_unlike
unlive92712333_unlive
urnlike1136713urnlike
woolie93514483wooli_e

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271486.62620227.4
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.09225196.1
 
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.