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

35 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
subdevelopments257169(None) 
subdevelopment2471861subdevelopment_
developments2053343___developments
nondevelopments2372283nondevelopments
redevelopments22172733_redevelopments
development1954214___development_
nondevelopment2272434nondevelopment_
predevelopment24202374predevelopment_
redevelopment21203274_redevelopment_
subemployments2571764sub_employments
antidevelopment23101375antidevelopment_
developmental2171905___developmental
envelopments1953435___envelopments
overdevelopment2681895overdevelopment_
subdepartments2181165subde_partments
subemployment2471965sub_employment_
subgovernments2271455subgove_rnments
bedevilments2052476_bedevil__ments
codevelopers2062136_codevelop_e_rs
deployments1954246___de_ployments
developers16123746___develop_e_rs
developes15155286___develop_e__s
developpes18142966___developpe__s
devilments1646386___devil__ments
envelopment1853946___envelopment_
redeployments2162206_rede_ployments
redevelopers1872096_redevelop_e_rs
revelments1546866___revel__ments
subbasements1852716subbase___ments
subdepartment2061276subde_partment_
subgovernment2171516subgove_rnment_
subsegments1653426sub__se__gments
underlayments1972646_unde_rlayments
undeveloped1852746_undevelop_e__d
unemployments22122536_u_nemployments

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 Filter178691950240.343520965.0
2DLD Change Limit95024356.40614833.6
3Display Results35350.0301166.7
 (SQL Overall)178691356.77926359.5
 
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.