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

42 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
standpoints145188(None) 
standpoint1353511standpoint_
endpoints1243493__endpoints
handprints1643973_handprints
sandpits1146843s_andp_i_ts
standdowns1552173standdown_s
standings11257153stand__ings
standouts1044983stand_o_uts
standpipes1543073standp_ipes
adjoints16103874__a_djoints
anoints7311064__an__oints
appoints1286404__a_ppoints
ballpoints1442904_ballpoints
cashpoints1752134_cashpoints
endpoint1147104__endpoint_
gunpoints1243274_gun_points
handprint1546984_handprint_
midpoints14103804__midpoints
penpoints1344554_pen_points
pinpoints1344154_pin_points
reanoints945364rean__oints
reappoints1443604rea_ppoints
sandlings11238094s_and_lings
sandlots938294s_andlo__ts
sandpiles1246304s_andp_iles
sandpit1049634s_andp_i_t_
sandworts1346454s_andwo_rts
shinsplints1671284shinsplints
stanchions1543664stanchion_s
standdown1442474standdown__
standfasts1452554stand_fasts
standing103413634stand__in_g
standoffs1642674stand_o_ffs
standout948664stand_o_ut_
standpat1145724standp__at_
standpipe1443344standp_i_pe
standstills1251444standstills
stanines85115674stan___ines
stinkpots1542624stinkpo__ts
strandlines1244974strand_lines
talapoins1144704_talapoin_s
waypoints1742444_wa_ypoints

Search took 10 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.420425454.8
2DLD Change Limit148819429.39315843.6
3Display Results42420.0133230.8
 (SQL Overall)178691429.82618185.5
 
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.