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

105 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
tangelos93574(None) 
tangelo837031tangelo_
angels74416172_angel_s
angelus8418462_angelus
anglos74413912_ang_los
mangels103614492mangel_s
tangents938712tangents
tanglers92911972tanglers
tangles83920042tang_les
tangos74216302tang__os
aneles64626293_an_eles
angel65019563_angel__
angeled93211513_angeled
angelic1039623_angelic
angers75222543_ange_rs
anglers84014823_anglers
angles74426703_ang_les
anglo65215373_ang_lo_
angulose945173_angulose
angulous946223_angulous
bagels95712313ba_gel_s
bangers104020353bange_rs
bangles103617413bang_les
bargellos1243323bargellos
cancels114113313cancel_s
candelas1139533candelas
cannelon1045123cannelon
cannelons1145213cannelons
cannels93413363cannel_s
danegelds1241773danegelds
danegelts1142443danegelts
dangerous1146103dangerous
dangers94818213dange_rs
danglers103610593danglers
dangles93618423dang_les
evangels1243733evangel_s
fangless1237663fangless
gangers94418603gange_rs
gangplow1541603gangplow
gangplows1641693gangplows
gangrels1094973gangrel_s
gingelis10247093gingelis
hangers113120813hange_rs
hansels104011663hansel_s
janglers16319373janglers
jangles154015683jang_les
kanteles1238123kanteles
langleys1245103langleys
langrels9106173langrel_s
magnetos1146263magnetos
mangel94017533mangel__
mangers103521263mange_rs
manges94628943mange__s
manglers113311903manglers
mangles104021463mang_les
mangolds1235193mangolds
mangos94319333mang__os
mantels94515043mantel_s
panels84716523pan_el_s
pangenes112612823pangenes
pangens103112063pange_ns
rangers83621043range_rs
ranges73826923range__s
sangers84421943sange_rs
santeros8311193santeros
taels56822073ta__el_s
taggers93514193tagge_rs
tanagers9259003tanage_rs
tandems1037633tande_ms
tanged84622493tange__d
tangence1146703tangence
tangences1246443tangences
tangency1444563tangency
tangent8314993tange_nt
tangibles1243953tangibles
tangle74019953tang_l_e
tangled94214633tang_led
tangler83515073tang_ler
tangly104413913tang_l_y
tango66921173tang__o_
tangrams1136163tangrams
tangs65028343tang___s
tankers113416913tanke_rs
tankless12267823tankless
tanners74018393tanne_rs
tanrecs934823tanre_cs
tantalous946193tantalous
tantalus836373tantalus
tapalos938813ta_palos
targes74524593targe__s
targets84314223targe_ts
tassels74510853tassel_s
telos55424523t___elos
tinges74722333tinge__s
tinglers93710593tinglers
tingles83818323ting_les
tinsels738373tinsel_s
tongers84116013tonge_rs
tunnels7328723tunnel_s
tupelos936113t_upelos
twangers12226063twange_rs
twanglers1363433twanglers
twangles1245743twang_les
wanglers123310033wanglers
wangles113416933wang_les

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621058.08018089.4
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.54620909.3
 
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.