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

39 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
plantsmen134414(None) 
plantsman1344671plantsman
clansmen1245722clan_smen
grantsmen1294642grantsmen
landsmen1156602_landsmen
plainsmen1343462plainsmen
bandsmen1356453_bandsmen
batsmen1146883_ba_tsmen
boatsmen1245283boa_tsmen
clansman1245813clan_sman
craftsmen1672913craftsmen
draftsmen1552673draftsmen
glassmen1145393gla_ssmen
grantsman1265053grantsman
huntsmen1343273_huntsmen
landmen1038553_lan_dmen
landsman1156853_landsman
lensmen937883_len_smen
linesmen1046563_linesmen
linksmen1443523_linksmen
pantrymen1643273p_antrymen
placemen1445783pla_cemen
plainsman1343193plainsman
planished1566123planished
planisher1495853planisher
planishes14138523planishes
plantain1047903plant_ain
planted103516123plant__ed
planter94017803plant__er
plantlet10310013plant_let
plants84921803plants___
plasmin112410033pla__smin
plasmon11257983pla__smon
platen84518203pla_t__en
playtime1544793playtime_
playtimes1644413playtimes
pointmen1245423point_men
raftsmen1343953_raftsmen
shantymen1762503shantymen

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 Filter1786911486410.453394461.4
2DLD Change Limit148641399.12316293.0
3Display Results39390.0331181.8
 (SQL Overall)178691399.60918596.2
 
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.