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

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
devas9621888(None) 
degas75119161degas
deva85720981deva_
devs86424031dev_s
divas95418581divas
bemas96424282bemas
betas75528762betas
dadas75819862dadas
dead65434242de_ad
deads75726912deads
deaf85838402de_af
deal56347412de_al
deals65435342deals
dean56039482de_an
deans66131392deans
dear55343602de_ar
dears65736882dears
deash95617242de_ash
deave95022332deave
deaves105319532deaves
debag94212302debag
debags104211062debags
debar85517862debar
debars94218042debars
debase94014472debase
debs76530242de_bs
debts86418372debts
decaf114919442decaf
decafs124010882decafs
decal85523232decal
decals93717712decals
decay114718482decay
decays124612912decays
decks124822192decks
decos85522122decos
dedal75719022dedal
dedans85915072dedans
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deets65330242deets
defat95426692defat
defats105114552defats
defis96717502defis
deils65722862deils
dekes105224452dekes
delay94820632delay
delays104014052delays
deles65139252deles
delfs94918672delfs
delis64928542delis
dells66630942dells
dels56745472de_ls
deltas74414822deltas
delts65731792delts
delves104917082delves
demast9517062demast
demes86032692demes
demos86022992demos
denar65223292denar
denars74621432denars
denes65639722denes
dens55945072de_ns
dents65031802dents
derat65044082derat
derats74625062derats
deray95024182deray
derays105514252derays
dermas94116812dermas
derms85022892derms
desks105913072desks
dev76033772dev__
devel94217122devel
devels104313902devels
devest104418702devest
devil94714732devil
devils104412812devils
devise104215752devise
devon95113682devon
devons104512252devons
dewan95718042dewan
dewans105215142dewans
dewar95817732dewar
dewars105117072dewars
dewax165510852dewax
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
ditas65923672ditas
diva85920882diva_
divan96114842divan
divans104612392divans
dives95832402dives
donas65926472donas
dopas85019062dopas
doves94728152doves
dumas85420432dumas
duras65727722duras
edemas9310502edemas
eras45441502_eras
etas46432272_etas
eves76230462_eves
eyas76427432_eyas
favas115618592favas
fetas85624402fetas
getas65421482getas
ideas65919012ide_as
javas155915422javas
kavas125919952kavas
keas86337092ke_as
kivas124614732kivas
kvas117015942_kvas
lavas85422222lavas
leas45954182le_as
leva77020712leva_
levis85818552levis
mesas76823202mesas
nemas75321572nemas
neves87021872neves
nevus84611392nevus
novas85215362novas
peas65755062pe_as
revs75027052rev_s
seas45755272se_as
selvas93812912selvas
teas45851492te_as
tepas76521682tepas
texas126514932texas
ulvas84511502ulvas
uveas84912282uveas
vas67755772__vas
vivas114815022vivas
wekas123911792wekas
yeas78638422ye_as
zetas145018162zetas

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 Filter178691538000.0931921408.6
2DLD Change Limit538001371.75030742.9
3Display Results1371370.0462978.3
 (SQL Overall)1786911371.88994595.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.