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

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

48 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
entertainers125366(None) 
entertainer1154481entertainer_
entertained1245172entertaine_d
entertains1047622entertain__s
entrainers1086962ent_r_ainers
enterprisers1462723enterprisers
entertain947863entertain___
entertaining1354383entertaining
entertainment1563053entertainment
entertainments1672453entertainments
entrainer968583ent_r_ainer_
interliners11138693inter_liners
intertwines1446643intertwine_s
attainers9115594_at__tainers
centerlines1346994center_line_s
certainer1146194__certainer_
detainers10269104__de_tainers
determiners1444644deter_miners
energizers2042904en_er_gizers
entailers976414en___tailers
enterers82214154enter____ers
enteritides1245844enteritide_s
enteritises1147724enteritise_s
enterpriser1363764enterpriser_
enterprises1355544enterprise_s
entrained1089414ent_r_aine_d
entrains8312964ent_r_ain__s
entrappers1444184ent_r_appers
entreaties1048114entreati_e_s
eternalness1153824e_ternalness
extermines1947784exter_mine_s
extortioners1952064extortioners
interlayers1445334interla_yers
interlinears12144584inter_linears
interliner101311154inter_liner_
interlines101116454inter_line_s
interties9320334intert_i_e_s
intertwine1347614intertwine__
intertwined1544594intertwine_d
interveners14107304inter_veners
intestines10410254intest_ine_s
nemertines1245964nemert_ine_s
restrainers1145124rest_r_ainers
retainers92510764__re_tainers
strainers9510384_st_r_ainers
trainers83114644__t_r_ainers
uncertainness1572334uncertainness
undertakers1643814underta_kers

Search took 8 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 Filter1786911247900.390458182.1
2DLD Change Limit124790486.76618443.7
3Display Results48480.0301600.0
 (SQL Overall)178691487.18624866.5
 
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.