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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

56 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
telecom114682(None) 
telecoms1246471telecoms
telco7511872tel_co_
telcos8710682tel_cos
celom9515693cel__om
elect74327033_elec_t
elector93313263_elector
elects83315003_elects
elevon977953_elevon
helicon1237643helicon
seldom939413sel_dom
select82621173selec_t
selector1048623selector
selects91912143selects
selfdom1343733selfdom
talcum1036953tal_cum
tearoom939063tearoom
teem66132603te_e__m
telamon936523telamon
tele45040873tele___
telecast1048303telecast
teledu737303tele_du
teledus835093teledus
telefax1743203telefax
telefilm1343463telefilm
telega736773tele_ga
telegas837443telegas
telegony1244223telegony
telegram1146003telegram
teleman959573teleman
telemen9310173telemen
teleonomy1453143teleonomy
teleost7410523teleost
teleport1048653teleport
teleran7510183teleran
teles54536003tele__s
telescope1355063telescope
telescopy1653013telescopy
teleses7313123teleses
teleshop1344713teleshop
telesis7310793telesis
telethon1146003telethon
telex125214823tele__x
telexed1536323telexed
telexes1438353telexes
telic76019823telic__
telium82611403tel_ium
teloi54217383tel__oi
telome8311923tel__ome
telos55424523tel__os
telson6310293tel_son
teredo7310783teredo_
teredos839183teredos
toledo7419993toledo_
toledos8388863toledos
welcome1445203wel_come

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.406440125.6
2DLD Change Limit134027568.76615289.4
3Display Results56560.0461217.4
 (SQL Overall)178691569.21819385.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.