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

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

31 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
osmoregulation176177(None) 
osmoregulations1861721osmoregulations
osmoregulatory2081103osmoregulatory
overregulation1864343overregulation
deregulation1446084__deregulation
morulation12148904__mor__ulation
nonregulation1473904_nonregulation
overregulations1963854overregulations
regulation11312054____regulation
reregulation1346414__reregulation
sporulation1346404_spor__ulation
coagulation1447275__co_agulation
crenulation1347575___crenulation
demodulation1644695demo__dulation
deregulations1545205__deregulations
formulation1646365__for_mulation
impregnation1754015_impreg_nation
modulation13147935__mo__dulation
morulations13148165__mor__ulations
osculation1249675os____culation
overeducation1955375o_vereducation
overregulating1963795overregulating
reformulation1853975refor_mulation
regulations12310715____regulations
reregulations1455715__reregulations
segregation1346385_segreg__ation
somnambulation2061555somnambulation
speculation1547545_s__peculation
sporulations1445685_spor__ulations
strangulation1464045_strangulation
stridulation1354775_s_tridulation

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.393454684.5
2DLD Change Limit95024316.31015059.3
3Display Results31310.0161937.5
 (SQL Overall)178691316.71926594.9
 
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.