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

115 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
devel9421712(None) 
bevel104517041bevel
devels104313901devels
devil94714731devil
kevel124213101kevel
level84116551level
revel84423161revel
bedel84219402bedel
betel74419902betel
bevels113913982bevels
bezel165215172bezel
daven94916472daven
deal56347412de_al
deave95022332deave_
deaved114916552deaved
deaves105319532deaves
decal85523232decal
deckel134911042deckel
dedal75719022dedal
dee47665822de_e_
deed65340902de_ed
deem75432892de_em
deep76031882de_ep
deer56739022de_er
dees56356632de_es
deet57356582de_et
defer94619752defer
defuel10348932defuel
deil56231622de_il
deke95228762deke_
deked115718532deked
dekes105224452dekes
del46752752d__el
dele56843082dele_
deled75326542deled
deles65139252deles
dell56938202de_ll
delve96018262delve_
delved114112752delved
delver104913492delver
delves104917082delves
deme76536282deme_
demes86032692demes
dene56643412dene_
denes65639722denes
dere56845902dere_
desex13311982desex
deter65028042deter
dev76033772dev__
deva85720982dev_a
devas96218882devas
devein1039142devein
develed123611932develed
develop13145032develop
devest104418702devest
devils104412812devils
devon95113682devon
devs86424032dev_s
dewed105020302dewed
dexes135224512dexes
diel59034602d_iel
diesel74410402diesel
dive85634772dive_
dived106321372dived
diver94827802diver
dives95832402dives
djebel1643452djebel
dove85131562dove_
doven94718552doven
doves94728152doves
dowel95618192dowel
drivel105110382drivel
duel56729702d_uel
duvet9321872duvet
dynel9569852dynel
eel37946842_e_el
eve66331162_eve_
even75222272_even
ever77027692_ever
eves76230462_eves
evil75318072_evil
feel75233842fe_el
fever115617952fever
gavel95815182gavel
heel75034222he_el
hovel115017682hovel
jebel145612142jebel
jewel156711702jewel
keel85729472ke_el
kevels134410712kevels
kevil12399862kevil
levee84023812levee
levels94113282levels
lever85125162lever
navel87016572navel
neve76224832neve_
never86218642never
neves87021872neves
newel86114132newel
novel85615992novel
peel65535612pe_el
ravel84621512ravel
rebel73421292rebel
reel45240532re_el
refel84920812refel
repel74921402repel
reveal94115052reveal
revels94220572revels
revet84938842revet
seel45042982se_el
seven84118312seven
sever85426052sever
teel46335802te_el
wedel94513962wedel
weel75834082we_el

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.330541487.9
2DLD Change Limit538001152.17024792.6
3Display Results1151150.0631825.4
 (SQL Overall)1786911152.56369719.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.