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

54 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
established175310(None) 
establisher1652831establisher
establishes1653451establishes
stablished1644221_stablished
establish1444742establish__
establishers1752222establishers
reestablished1962142reestablished
stablishes1545372_stablishes
unestablished1962092unestablished
disestablished2191783disestablished
establishing1852823establishing
establishment20132673establishment
nonestablished2071433nonestablished
preestablished2271733preestablished
reestablishes1862213reestablishes
stabilised13104593_stabilis_ed
stablish1348343_stablish__
abolished1544274___abolished
astonished1443404ast_onished
copublished2151984copublished
destabilized2563744destabilized
disestablishes2071874disestablishes
embellished1951824embellished
englished1444274e__nglished
enravished1742194enra_vished
equalised1945474equa_lis_ed
espaliered1341974espa_liered
establishable2061384establishable
establishments21132234establishments
evanished1644334e_va_nished
metalised12310464meta_lis_ed
outblushed1643154out_blushed
preestablishes2161744preestablishes
published1744344__published
reestablish1653104reestablish__
republished1952944republished
restabilized2464064restabilized
restabled12148964restabl___ed
stabilise1197084_stabilis_e_
stabilises12116014_stabilis_es
stabilized22105624_stabilized
stabled103514954_stabl___ed
stablishing1753544_stablishing
stablishment19143114_stablishment
standishes1445714_standishes
starfishes1646154_starfishes
stashed113812494_sta___shed
stonished1345594_st_onished
stylised12215894_st_ylis_ed
tarnished13196064__tarnished
totalised1048074tota_lis_ed
unpublished1952084unpublished
untarnished1553084untarnished
vitalised1347204vita_lis_ed

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 Filter1786911488190.436409841.7
2DLD Change Limit148819548.50017508.1
3Display Results54540.0331636.4
 (SQL Overall)178691548.96919923.2
 
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.