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

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
platypi144275(None) 
platy105021662platy__
platypus1542352platypus
platys11459852platy_s
atypic13337653__atypic
lathi85417203_lat_hi
lati46438273_lat__i
palpi95414553p_a_lpi
pappi84810893p_a_ppi
papyri1334903p_apyri
paty95234563p_aty__
peaty105725693peaty__
plat66048873plat___
platan83913693plat_an
platane93112303platane
platans93413123platans
plate74635113plat__e
plateau937403plateau
plated95225773plat_ed
platen84518203plat_en
platens94213983platens
plater84427693plat_er
platers93924093platers
plates85432243plat_es
platier93716293platier
platies93722543platies
platina94413643platina
plating103823073plating
platinic1237073platinic
platonic1238773platonic
platoon938953platoon
plats75531373plat__s
platted103614263platted
platter93917413platter
platyfish2042683platyfish
play95928983pla_y__
playa105812943pla_y_a
playas114612283pla_yas
played124815033pla_yed
player115215213pla_yer
playpen1434693pla_ypen
plays106320773pla_y_s
plutei8408903plut_ei
polypi13458593p_olypi
polytype1844753polytype
polytypic2143943polytypic
pretype14387483pretype
slaty86523153slaty__

Search took 8 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 Filter1786911340270.440406115.9
2DLD Change Limit134027486.53020524.8
3Display Results48480.0163000.0
 (SQL Overall)178691486.98625578.4
 
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.