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

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

60 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
diversified196296(None) 
diversifier1862681diversifier
diversifies1853811diversifies
diversifiers1982032diversifiers
diversities1555882diversities
versified16147602__versified
decertified1853933decertified
densified1446713d__ensified
desertified1654103desertified
diversify1943463diversif__y
diversifying2352163diversifying
nondiversified227983nondiversified
reverified1745123rever_ified
verbified18146023__verbified
verified151510403__ver_ified
versifier15156533__versifier
versifies15159333__versifies
adversities1564354adversities
aerified121310144__aer_ified
certified1548424__certified
decertifies1744574decertifies
deified123112414d__e__ified
demulsified1852394demulsified
densifies1347994d__ensifies
desertifies1544704desertifies
devitrified1952714devitrified
dignified1545574di__gnified
dimensioned1552464dimensioned
dimerized2246234dimer_i_zed
diverged14256884diver___ged
diverse11429994divers___e_
diversion1346454divers__ion
diversionist1654514diversionist
diversions1446534diversi_ons
diversity1645224divers__ity
diverted13199584diver___ted
divested13268214dive_s__ted
esterified1445404ester_ified
etherified1744084ether_ified
identified1545054_identified
intensified15104014intensified
liveried1238734liver___ied
micrified17126804mi_cr_ified
nigrified1445334ni_gr_ified
nitrified1346734ni_tr_ified
oversized221710154_oversi_zed
recertified1754344recertified
reverifies1645974rever_ifies
riverside1344914riversi_de_
riversides1444334riversi_des
sissified1345544si__ssified
terrified13147584__terrified
uncertified17124634uncertified
universities1553454universities
verbifies17157134__verbifies
verifier14159204__ver_ifier
verifies141313484__ver_ifies
versifiers16154144__versifiers
vitrified1645984vi_tr_ified
vivified1845894viv___ified

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 Filter1786911488190.423422437.4
2DLD Change Limit148819609.06316420.5
3Display Results60600.0302000.0
 (SQL Overall)178691609.51618778.0
 
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.