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

46 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
corrugate125548(None) 
corrugated1444431corrugated
corrugates1345181corrugates
conjugate1945012conjugate
correlate1149042correlate
arrogate91210323_arrogate
circulate13810433circulate
cirrate92413493cirr__ate
coadunate1245643coadunate
coagulate1258083coagulate
coarctate1344823coarctate
cocreate122611813cocr_eate
coequate1946153coequ_ate
colligate1248293colligate
commutate1547063commutate
congregate1445243congregate
conjugated2144143conjugated
conjugates2044693conjugates
consulate11612233consulate
copulate122614113co_pulate
cordate10315223co_r_date
corelate10516013co_relate
cornute939643cornu__te
corollate1148123corollate
coronate103018213co_ronate
corotate102813933co_rotate
corporate13410903corporate
corrade101111043corr__ade
correlated1346683correlated
correlates1248673correlates
corrugating1544263corrugating
corrugation1445993corrugation
corrupt1149103corru_pt_
corrupted1444503corru_pted
corrupter1344543corru_pter
corrupts1244983corru_pts
corticate13410763corticate
coruscate1346053coruscate
formulate1446993formulate
fortunate1245453fortunate
irrigate967633_irrigate
prorogate1247693prorogate
rugate75813813___rugate
serrulate946983serrulate
surrogate1044783surrogate
torquate1745003torqu_ate

Search took 8 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.436409841.7
2DLD Change Limit148641467.45319943.8
3Display Results46460.0162875.0
 (SQL Overall)178691467.90522604.8
 
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.