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

103 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
artel5612274(None) 
ariel55228971ariel
artal55525471artal
artels66216231artels
cartel85022531cartel
ratel54224881ratel
acted88521732acted
after85719792after
airted74214502airted
alter54828502alter
angel65019572angel
ante46538902ante_
anted66328242anted
antes56334322antes
aortal65217512aortal
appel94615892appel
apter76120202apter
arced88224162arced
ardeb8314522ardeb
are37874572ar_e_
area45843392ar_ea
areal55928732areal
ares45871022ar_es
arete56031352arete
aretes64425352aretes
argal65023392argal
argil65116882argil
argle65421562argle
argol65317262argol
ariels65119372ariels
aril45843022ar_il
arles56735742arles
armed86324432armed
armer76924442armer
armet76739452armet
arpen74418042arpen
arse46539272arse_
arses55733872arses
art38679142art__
artery9911452artery
artful968272artful
artier63419732artier
artily92814712artily
arts49650262art_s
artsy86012962artsy
arty77531312art_y
arval86017012arval
aryl75922342ar_yl
aster55434892aster
ate37059242a_te_
ates45047922a_tes
axel115222072a_xel
barbel104317072barbel
barrel84517882barrel
barter85525382barter
betel74419902betel
botel75121862botel
carcel105018672carcel
carpel105418472carpel
carrel84718632carrel
carte75940422carte_
carted98631442carted
cartels94618122cartels
carter84932272carter
cartes86239472cartes
carvel114817572carvel
creel75121482creel
cruel74815902cruel
darnel74312182darnel
darted84620922darted
darter75320362darter
dartle73714832dartle
fardel104712592fardel
farfel124310432farfel
farted105121782farted
garter74420512garter
gruel66014742gruel
hartal9415472hartal
hotel85520752hotel
mantel84317972mantel
marcel103714852marcel
marted94425212marted
marten84518262marten
marvel113712002marvel
motel76623242motel
oriel54920422oriel
parcel103915472parcel
parrel84515982parrel
parted94228682parted
pastel85918712pastel
ratal55025112ratal
rate45458762rate_
rated65441382rated
ratels64518212ratels
rater54943282rater
rates55352012rates
ravel84621512ravel
reel45240532_reel
riel46432382_riel
tarted74923372tarted
tarter64023562tarter
tel35647902__tel
warted104223232warted

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.313570897.8
2DLD Change Limit538001031.68631909.8
3Display Results1031030.0333121.2
 (SQL Overall)1786911032.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.