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 “stripteases” 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
stripteases135268(None) 
striptease1252511striptease_
stripteaser1351661stripteaser
stripteasers1471411stripteasers
straplesses1353283straplesses
strictnesses1445413strictnesses
stripeless1243283strip_eless
triptanes1147463_tript_anes
caritases1139764cari_t_ases
periphrases1853584periphrases
proteases112110834_pr_oteases
scripters13116684scripte__rs
scriptures1443794script_ures
slipcases1364264s_lip_cases
staidnesses1237194staidnesses
stainlesses1144164stainlesses
staircases1243464stai_rcases
steepnesses1345924steepnesses
stipulates1256684st_ipulates
straitnesses1246214straitnesses
strapless1135794straple_s_s
strategies1155594str_ategies
stresses81112494str___esses
striates83417084stri___ates
strictest1147294stricte_s_t
strictness1245644strictnes_s
strictures1246174strict_ures
stridences1344734stri_dences
stridulates1254544stridulates
strifeless1343214stri_feless
stripers103911594strip_e__rs
stripes95320574strip____es
stripiest1138024stripie_s_t
strippers1355774strippe__rs
suitcases1144454s_ui_tcases
surceases1157474sur__ceases
trapeses1039154_trap_e_ses
tricepses1354644_tri_cepses
trichiases1544564_trichiases
trignesses1188214_trignesses
trimnesses1287754_trimnesses
triphase1346194_trip_hase_
triplanes1148804_trip_lanes
triplexes1844254_triple_xes
triposes1039974_trip__oses
triptane1047564_tript_ane_
triptans1047364_tript_a_ns
triteness9310364_tri_teness

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.406440125.6
2DLD Change Limit148819488.45317605.5
3Display Results48480.0301600.0
 (SQL Overall)178691488.88920102.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.