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 “superphosphates” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

51 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
superphosphates2413123(None) 
superphosphate23111541superphosphate_
pyrophosphates2671514__pyrophosphates
diphosphates23143045___diphosphates
metaphosphates2691715_metaphosphates
orthophosphates2481405orthophosphates
phosphates2087165_____phosphates
pyrophosphate2571595__pyrophosphate_
superovulates1863565super__ovulates
superposes1448935superp_os____es
superstates1349555super___s_tates
triphosphates2362375__triphosphates
diphosphate22113186___diphosphate_
metaphosphate2591936_metaphosphate_
nonphosphate2262176__nonphosphate_
orthophosphate2381476orthophosphate_
phosphate1977276_____phosphate_
phosphites2087046_____phosphites
saprophytes2154576sap_r__o_phytes
spermatophytes26112326s_permatophytes
spermophiles2153076s_per_mo_philes
sporophytes2154986s_por__o_phytes
superannuates1564126super__annuates
superchurches2562086superchurch__es
supercomputer2172556super_comp_uter
supercomputers2292056super_comp_uters
superelevates1872916super__elevates
superheated1746666super_h___eated
superheater1646476super_h___eater
superheaters1755396super_h___eaters
superheats1548216super_h___eat_s
superhypes20135166super_h_yp___es
superinsulated1762296super_insulated
supernates12413266super_____nates
superovulate1753586super__ovulate_
superovulated1962846super__ovulated
superphysical2571696superphysica__l
superplanes1547436super____planes
superpolite1556906superp_o__lite_
superports1447836superp_o___rt_s
superposable1852836superp_os__able
superpose1349026superp_os____e_
superposed1546646superp_os____ed
superpositions18145266superp_ositions
superprofits1953466superpro__fit_s
supersales12411246super___s__ales
supersaturates16104426super_saturates
superspies1449296super___sp__ies
superstate1249836super___s_tate_
superstimulates1982346superstimulates
triphosphate2262426__triphosphate_

Search took 9 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 Filter178691950240.390458182.1
2DLD Change Limit95024517.78012213.9
3Display Results51510.0301700.0
 (SQL Overall)178691518.20021791.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.