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 “nolo” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

207 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
nolo4622931(None) 
bolo65535951bolo
kolo87026231kolo
nolos54423351nolos
noo37154041no_o
polo66236631polo
solo45538941solo
anglo65215382anglo
anole55330382anole
boho96923322boho
bola66035562bola
bold75432812bold
bole66448692bole
boll65634752boll
bolos75531372bolos
bolt66254172bolt
boo58163662bo_o
boyo96923842boyo
bozo156821412bozo
calo64936442calo
cholo105217972cholo
coco87330602coco
coho97524492coho
col59360352col_
cola66541392cola
cold77338772cold
cole66956112cole
colog86619932colog
colon78630192colon
color76123742color
cols66553082cols
colt67158242colt
coly96940532coly
coo59566362co_o
cool66940492cool
dodo66024922dodo
dojo126016142dojo
dol47150652dol_
dole56550002dole
doll56632492doll
dolor67617962dolor
dols56943052dols
dolt56649422dolt
enol45823822enol_
enols54718402enols
filo76034292filo
fold86528942fold
folio83820882folio
folk116021542folk
fool75330592fool
gobo76126902gobo
gogo69722832gogo
gold65430162gold
golf85731182golf
goo47754772go_o
halo76437322halo
helo75332852helo
hobo97026082hobo
hold86235062hold
hole77553392hole
holk116027942holk
hollo84822162hollo
holm95628112holm
holp95727552holp
hols76946292hols
holt77852582holt
holy106333432holy
homo96126472homo
jole117233822jole
jolt116639122jolt
kilo86028682kilo
knoll9389602knoll
kobo107422112kobo
kola85124972kola
kolos94921212kolos
koto86323482koto
lilo46731572lilo
lo28053442__lo
lobo67229862lobo
loco67030742loco
logo57931762logo
loll46128382loll
loo38359822lo_o
milo65536112milo
mojo136917222mojo
mol56654592mol_
mola66035632mola
mold76034332mold
mole66251832mole
moll66735702moll
mols65948572mols
molt66356162molt
molto75619602molto
moly96031912moly
mono66036722mono
moo58460512mo_o
mool67533862mool
mozo157719742mozo
nala46930392nala
nil36144202nil_
nill45634312nill
nils46132462nils
no29353242n__o
nob58954422no_b
noble74420992noble
nobly105314402nobly
nobs66436902nobs
nock106127182nock
nod47549572no_d
node513036892node
nodi56626752nodi
nods55838232nods
noel45226552noel
noels56418702noels
noes45845392noes
nog46847312no_g
nogg65115942nogg
nogs56534612nogs
noh66640642no_h
nohow1137292nohow
noil46133242noil
noils55024332noils
noily86120992noily
noir46722432noir
nom510450642no_m
noma67529462noma
nome66038422nome
nomoi76012532nomoi
nomos75919742nomos
noms65636402noms
nona46929062nona
none45743172none
nook85728492nook
noon47134622noon
nope65934192nope
nor38048822no_r
nori47133142nori
norm66429812norm
nos38859322no_s
nose46739362nose
nosh76223542nosh
nosy76322892nosy
not39474662no_t
nota46830772nota
note46239962note
noun45724182noun
nous46136982nous
nova76518952nova
now65950192no_w
nows75738232nows
nowt78833752nowt
null45125312null
nylon82910512nylon
oho66534382_oho
old47033472_old
ole37155212_ole
oleo46630482_oleo
olio46829672_olio
only75319722only
ono36838032_ono
onto46127662onto
ovolo8339172ovolo
oxo107322962_oxo
poco86826152poco
pol56449382pol_
pole65951302pole
polio75722552polio
poll66332132poll
polos76129912polos
pols66044562pols
poly96235152poly
pomo85828452pomo
poo57757112po_o
pool65835952pool
role45851822role
rolf75134872rolf
roll46331652roll
roto45935052roto
silo46037922silo
snool55118642snool
sol37256622sol_
sola45541862sola
sold54837412sold
soldo67116562soldo
sole46053672sole
soli46637012soli
solon55026132solon
solos54830792solos
sols45448162sols
tola45236332tola
told56132202told
tole46052902tole
toll45535262toll
tolu45529152tolu
too38965422to_o
tool46735682tool
topo66932402topo
toro48045682toro
toyo76925452toyo
vole75236982vole
volt76439532volt
wold85429072wold
wolf105729562wolf
woo66949802wo_o
wool76427372wool
yolk116218992yolk
zoo126238912zo_o

Search took 2 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 Filter178691298720.266671770.7
2DLD Change Limit298722070.76638997.4
3Display Results2072070.0464500.0
 (SQL Overall)1786912071.078165761.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.