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

175 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
dopas8501906(None) 
donas65926471donas
dopa77220901dopa_
dopes84935041dopes
adopts998082adopts
boas66150832bo_as
bolas74733762bolas
bops86037982bop_s
boras75938302boras
botas75328782botas
cocas95926572cocas
codas84724242codas
colas75436772colas
comas95833002comas
compas125817062compas
copal95621782copal
copals105018942copals
copay126516312copay
copays134911272copays
copes97747102copes
copras103517152copras
cops86751372cop_s
dadas75819862dadas
daps77239162dap_s
degas75119162degas
devas96218882devas
dips75536912dip_s
dipsas9359892dipsas
ditas65923672ditas
divas95418582divas
doat56947672do_at
doats65224882doats
doblas93812292doblas
dobras94811912dobras
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doffs125614332doffs
doges75630162doges
dogmas105011242dogmas
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolmas95213042dolmas
dols56943052do_ls
dolts65626312dolts
domal85619202domal
domes85735562domes
doms76239572do_ms
dona55529632dona_
dongas84914612dongas
dongs76525812dongs
donnas75511322donnas
dons56048702do_ns
dooms85321342dooms
doors65022132doors
dopant9316132dopant
dopants1038432dopants
dope76038892dop_e
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
dopy106224152dop_y
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dorsa64617282dorsa
dos48062312do__s
doses65938502doses
doss56235042do_ss
dotal64919622dotal
dotes65836692dotes
dots55647662do_ts
doulas75114992doulas
doumas95314812doumas
doums85417642doums
douras75016722douras
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
drops85719502drop_s
dumas85420432dumas
dupes86425932dupes
dups75929512dup_s
duras65727722duras
fops96532682fop_s
goas55239942go_as
hopes105835642hopes
hops97942632hop_s
horas86333102horas
hoyas115016162hoyas
iotas54821112iotas
jotas125717442jotas
kapas116021732kapas
koas85635092ko_as
kolas94822232kolas
kophs145010932kophs
koppas14407602koppas
kops107031292kop_s
koras95927112koras
lopes76437342lopes
lops66043352lop_s
lotas55926302lotas
moas65545342mo_as
molas75132092molas
monas74732152monas
mopes95134982mopes
mops85940132mop_s
moras76438772moras
moxas145014392moxas
napas75924352napas
nipas77116672nipas
nomas74726412nomas
nonas55126652nonas
nopal75517102nopal
nopals84914022nopals
novas85215362novas
obas65730932_obas
ocas66729632_ocas
odas57230262_odas
okas85225392_okas
oops65232672oop_s
opah96218402_opah
opahs105411982_opahs
opal66923522_opal
opals75718352_opals
opes65942612_opes
ops56641252_op_s
opts68124742_opts
opus66420592_opus
papas94927492papas
pas58775742__pas
popes95933812popes
poppas93710712poppas
pops86340952pop_s
pupas95219282pupas
qophs19507812qophs
ropes75940062ropes
rotas54827722rotas
soaps75120712soaps
sobas74424252sobas
socas74026182socas
sodas64123542sodas
sofas85320712sofas
sojas124716392sojas
somas76030372somas
sophs104916022sophs
sops65244562sop_s
soras55041012soras
soyas84520912soyas
spas67036722_spas
tapas74627712tapas
tepas76521682tepas
toeas55726422toeas
togas67823002togas
tolas54532772tolas
topaz16315322topaz
topes76941762topes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
toras55540372toras
upas68322382_upas
wops96634152wop_s
yogas96615602yogas
zoeas145815612zoeas

Search took 3 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 Filter178691538000.0961861364.6
2DLD Change Limit538001751.89028465.6
3Display Results1751750.0463804.3
 (SQL Overall)1786911752.03287938.5
 
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.