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

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

186 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
tangelo83703(None) 
tangelos935741tangelos
angel65019562_angel_
angels74416172_angels
anglo65215372_ang_lo
mangel94017532mangel_
mangels103614492mangels
tanged84622492tange_d
tangent8314992tangent
tangle74019952tang_le
tangled94214632tangled
tangler83515072tangler
tangles83920042tangles
tangly104413912tang_ly
tango66921172tang__o
anele55628833_an_ele
angeled93211513_angeled
angelic1039623_angelic
angelus8418463_angelus
anger66225873_ange_r
angerly1137773_angerly
angers75222543_angers
angle64528873_ang_le
angled84219093_angled
angler74017863_angler
angles74426703_angles
anglos74413913_ang_los
bagel85116793ba_gel_
bagels95712313ba_gels
banged104923723bange_d
banger94423633bange_r
bangers104020353bangers
bangle94018953bang_le
bangles103617413bangles
bargello1144143bargello
cancel105316683cancel_
cancels114113313cancels
candela1089743candela
cannel84216403cannel_
cannelon1045123cannelon
cannels93413363cannels
danegeld1142833danegeld
danegelt1045093danegelt
danged94819483dange_d
danger83722823dange_r
dangers94818213dangers
dangle84119303dang_le
dangled104013153dangled
dangler96912813dangler
dangles93618423dangles
dangly114212263dang_ly
evangel1134303evangel_
evangels1243733evangels
fanged114318223fange_d
ganged94619193gange_d
ganger83721463gange_r
gangers94418603gangers
gangly113911583gang_ly
gangplow1541603gangplow
gangrel996143gangrel_
gangrels1094973gangrels
gingeli9286153gingeli
gingely12378213gingely
hanged114222393hange_d
hanger104023253hange_r
hangers113120813hangers
hangul1049213hangul_
hansel95214373hansel_
hansels104011653hansels
jangle144416293jang_le
jangled164111563jangled
jangler153811833jangler
jangles154015683jangles
jangly174310603jang_ly
kantele1138253kantele
lanely93914483lan_ely
langley1147453langley
langrel8107033langrel_
langrels9106173langrels
largely1136703largely
magneto1046743magneto
mange84930193mange__
manger94325003mange_r
mangers103521263mangers
manges94628943mange_s
mangey123614523mange_y
mangily1339753mangily
mangle93921323mang_le
mangled113615263mangled
mangler103215643mangler
mangles104021463mangles
mango85724323mang__o
mangold1137213mangold
mantel84317973mantel_
mantels94515043mantels
panel76023623pan_el_
panels84716523pan_els
panged104722333pange_d
pangen94115913pange_n
pangene102711963pangene
pangens103112063pangens
range64728413range__
ranged84824313range_d
ranger73925523range_r
rangers83621043rangers
ranges73826923range_s
sagely102811383sa_gely
sanely93114613san_ely
sanger74524563sange_r
sangers84421943sangers
santero7311133santero
stanged94113843stange_d
strangely1345413strangely
tael46030713ta__el_
taels56822073ta__els
tagged93418123tagge_d
tagger84017703tagge_r
taggers93514193taggers
tamely113711953ta_mely
tanager83010943tanage_r
tanagers9259003tanagers
tandem9311403tande_m
tandems1037633tandems
tang56138673tang___
tanga64923693tang__a
tangence1146703tangence
tangency1444563tangency
tangents938713tangents
tangible1145603tangible
tangibly1444673tangibly
tangier83013903tangier
tangiest92915223tangiest
tanging93419523tanging
tanglers92911973tanglers
tangoed9318833tangoed
tangos74216303tang_os
tangram1038073tangram
tangs65028343tang__s
tangy94519933tang__y
tanked113919293tanke_d
tanker104521123tanke_r
tankers113416913tankers
tanned75219953tanne_d
tanner63722283tanne_r
tanners74018393tanners
tannery10388663tannery
tannest72617853tannest
tanrec837803tanre_c
tanrecs934823tanrecs
tanto55724943tan__to
tapalo839793ta_palo
targe65227093targe__
targes74524593targe_s
target75028903targe_t
targets84314223targets
tassel66014773tassel_
tassels74510853tassels
tenge65720433tenge__
tensely1037363tensely
tinge64626623tinge__
tinged84220803tinge_d
tinges74722333tinge_s
tingle74319063ting_le
tingled93712803tingled
tingler83613343tingler
tingles83818323tingles
tingly103815973ting_ly
tinsel639443tinsel_
tinsels738373tinsels
tonged86518903tonge_d
tonger74719683tonge_r
tongers84116013tongers
tunnel64310633tunnel_
tunnels7328723tunnels
tupelo836483t_upelo
twanged12387273twange_d
twanger11327433twange_r
twangers12226063twangers
twangle1145803twang_le
twangled1364173twangled
twangler1244113twangler
twangles1245743twangles
wangle103817503wang_le
wangled123312413wangled
wangler113312653wangler
wangles113416933wangles

Search took 10 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271868.98314920.1
3Display Results1861860.0632952.4
 (SQL Overall)1786911869.20219418.7
 
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.