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

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

69 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
telex12521482(None) 
tele45040871tele_
teles54536001teles
celeb9314872celeb
culex144613932culex
dele56843082dele_
deled75326542deled
deles65139252deles
desex13311982desex
fedex1699602fedex
flex146123472_flex
gelee63626982gelee
helix154413012helix
ilex115822032_ilex
kelep116014562kelep
lex107943822__lex
melee73729102melee
pele65539552pele_
peles75738082peles
plex137321372_plex
reflex16359512reflex
relax124817802relax
relet54749822relet
remex146315792remex
silex123417412silex
stele55026842stele_
steles63725662steles
tale46154162tale_
taler56034862taler
tales55451372tales
tee38366872te_e_
teed55439262te_ed
teel46335802te_el
teels55726372teels
teem66132602te_em
teen45938202te_en
tees45353582te_es
tel35647902tel__
tela45532972tel_a
telae54323292telae
telco7511872telco
teledu737302teledu
telefax1743202telefax
telega736772telega
telexed1536322telexed
telexes1438352telexes
telfer9379892telfer
telia55821142telia
telic76019822telic
tell44934702tel_l
teller63519812teller
tells55828942tells
telly84920822telly
telnet6518832telnet
teloi54217382teloi
telos55424522telos
tels46841692tel_s
tenet55542212tenet
tepee74724212tepee
tewed94718532tewed
tile45451442tile_
tiled64832942tiled
tiler56131022tiler
tiles55542102tiles
tole46052902tole_
toled65934922toled
toles55147132toles
tule45735872tule_
tules54532792tules

Search took 2 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 Limit53800691.61033416.1
3Display Results69690.0135307.7
 (SQL Overall)178691691.95391495.6
 
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.