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

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
corrupted144450(None) 
corrupter1344541corrupter
cornuted1137472cornu_ted
corrected1438112corrected
corrugated1444432corrugated
corrupt1149102corrupt__
corrupters1444022corrupters
corruptest1483562corruptest
corruptly1643092corruptly
corruptor1344042corruptor
corrupts1244982corrupt_s
incorrupted1652872incorrupted
irrupted1143122_irrupted
chirruped1742163chirrup_ed
circuited1444563circuited
cirriped1344183cirrip_ed
coadapted1543163coadapted
coapted123911503co__apted
cocreated142710093cocreated
coempted1535333co_empted
coequated2144823coequated
coerected1447643coerected
combusted1644643combusted
commuted15288983commu_ted
compted143813523co__mpted
computed154110953compu_ted
conducted1547313conducted
confuted1437683confu_ted
consulted1277923consulted
coopted123710763co__opted
corelated12411823corelated
cornute939643cornu_te_
coronated123313323coronated
coroneted12278323coroneted
corotated122810053corotated
corraded12128293corr_aded
corralled1245283corralled
correcter1348103correcter
correlated1346683correlated
corroded12147513corr_oded
corrugate1255483corrugate_
corrugates1345183corrugates
corrupting1555583corrupting
corruption1455373corruption
corruptive1754393corruptive
corruptness1552753corruptness
corruptors1443893corruptors
corseted11311473co_rseted
coscripted1752923coscripted
cotrustee1145583cotrustee
counted103815803co__unted
couped115019313co__up_ed
coupled124312673co__upled
courted103514923co__urted
croqueted2143313croqueted
crusted103712753c__rusted
disrupted1345973disrupted
erupted10207163__erupted
larruped1142863larrup_ed
worrited1235743worr_ited

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 Filter1786911486410.436409841.7
2DLD Change Limit148641606.47022973.9
3Display Results60600.0302000.0
 (SQL Overall)178691606.93625762.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.