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

59 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
pieplant126873(None) 
pieplants1355431pieplants
preplant12712911preplant
displant11412222displant
implant11311332_implant
misplant12410762misplant
preplan1149952preplan_
preplans1249612preplans
replant93318532_replant
airplane1067793airplane
appellant1346353appellant
ashplant1345413ashplant
biplane1139033bi_plane
deplane10311413_deplane
diplont10311693di_plont
displants1248073displants
eggplant1243973eggplant
elephant1347563elephant
explant16310133_explant
gelant72821673_ge_lant
gellant83214053_gellant
implants1237883_implants
libelant1048563libelant
libellant1145693libellant
misplan1147773misplan_
misplans1238863misplans
misplants1347313misplants
overplant142510713overplant
peasant9314923p_easant
peccant13311733p_eccant
pedant9319493p_e_dant
pendant10314853p_endant
peneplane1344663peneplane
pennant9312493p_ennant
pepla9312863p_epla__
petulant1048793petulant
pheasant1347083pheasant
piedmont1345273piedmont
pineland1145893pineland
pinpoint1248993pinpoint
pipeline12149503pipeline
piquant1848003pi_quant
pissant91012503pi_ssant
plant75437113___plant
pleasant1048323pleasant
pregnant1149883pregnant
preplace1488983preplace
preprint12314183preprint
reimplant1395303reimplant
replan83215823_replan_
replans92814943_replans
replants102811243_replants
reptant92817073_reptant
sealant73118303_sealant
sibilant10158273sibilant
simulant1048083simulant
supplant1247823supplant
vigilant1246423vigilant
waxplant20144603waxplant

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit146162596.45322650.2
3Display Results59590.0301966.7
 (SQL Overall)178691596.88925938.6
 
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.