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 “pantdress” 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
pantdress124335(None) 
pantdresses1443742pantdresses
actress948533_act_ress
address956103_a_ddress
ancress978613_an_cress
antipress1146413_antipress
antres65021003_ant_re_s
banterers112410003banterers
cateress102311603ca_teress
coatdress1243183coatdress
handless123512063han_dless
handpress1544033handpress
huntress1144833hunt_ress
landless94011173lan_dless
laundress1042813laundress
mandrels1137313man_drels
mattress1036533ma_ttress
minidress1243573minidress
outdress9137313_outdress
padres95016983pa__dre_s
palterers11249533palterers
pancreas1235393pan_creas
panderers12229153panderers
panders103423733pan_d_ers
pandies104224503pan_die_s
pandores11312453pandore_s
paneless102611763pan_eless
pantalets1147673pantalets
panthers13510783pant_hers
panties94230933pant_ie_s
pantiles103617153pantile_s
pantries101817393pant_ries
pastiness112312353pastiness
pastless102411203past_less
pastness102510503past_ness
pasturers1136393pasturers
pastures10311963pasture_s
pathless13138043pa_thless
patness92912283pa_t_ness
patterers112410123patterers
porteress1137923porteress
portress1038313port_ress
sandless93212343san_dless
spandrels1243253span_drels
sundress936983sun_dress
undress838893_un_dress
waitress1135223wait_ress
wardress12256163wa_rdress

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.220812231.8
2DLD Change Limit148641489.61015467.3
3Display Results48480.0301600.0
 (SQL Overall)178691489.86018122.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.