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

66 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
typeset126774(None) 
typesets1343211typesets
types105721062types__
typiest1238202typies_t
typist1139822typis_t
beset76739133__beset
boneset9316433boneset
bypast13117373bypas_t
capelet11517073capelet
cyeses11510123cy_eses
cypreses1535143cypreses
eyelet9514533ey_elet
hypes135818673hypes__
peseta8310573__peseta
pest65555293__pes_t
preset84430983_preset
reset55051863__reset
ripest84317943ripes_t
tamest85721293tames_t
tapered102612933tapered
taperer92511793taperer
tapes75838603tapes__
tapises92914013tapises
tappet103820113tap_pet
tasset65925313t_asset
teleses7313123teleses
tempest1139223tempes_t
tenet55542213t__enet
tepee74724213tepe_e_
tepees84215243tepe_es
test48651623t__es_t
these86519013t_hese_
theses96517973t_heses
tippet103917873tip_pet
tmeses85712243t_meses
topee76029953tope_e_
topees85519703tope_es
topes76941763topes__
trapesed1136473trapesed
trapeses1039153trapeses
trevet94818913t_revet
truest64816193trues_t
tweet84823983t_we_et
twinset1039373twinset
tyee75131423ty_e_e_
tyees86019453ty_e_es
tyes76433373ty_es__
tykes125817063tykes__
tynes85920303tynes__
type96223743typ__e_
typebar1442993typebar
typecase1543463typecase_
typecases1643853typecases
typecast1545273typecast
typed115815453typ__ed
typesetter1551823typesetter
typey135511883typ__ey
typhose1546693typhose_
typhuses1643763typhuses
typier1137333typ_ier
typists1236173typists
typos106015813typos__
typps12549303typps__
tyres84725233tyres__
upset73222593_up_set
yeses85119323_y_eses

Search took 7 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 Limit134027665.81323056.4
3Display Results66660.0302200.0
 (SQL Overall)178691666.24928595.1
 
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.