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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
delegation123888(None) 
delegations1348031delegations
denegation1249411denegation
relegation11610021relegation
allegation1146812allegation
deaeration11313012deaeration
defecation1679802defecation
delation92318082del__ation
delectation1448552delectation
delegating1337672delegating
delegator1146242delegat_or
deletion92011972dele__tion
denegations1348542denegations
derogation12410392derogation
elevation1239232_elevation
legation92412932__legation
relegations1248972relegations
abnegation1345413abnegation
allegations1246043allegations
celebration1546463celebration
deaerations12311673deaerations
dealation10313003de_alation
deceleration1547173deceleration
deception1448323dece_ption
decimation15411623decimation
declamation1646103declamation
declaration1447833declaration
declination14411873declination
decoration13314423decoration
dedication14311963dedication
defamation1646843defamation
defecations1779003defecations
defection151610643defe_ction
deflagration1773473deflagration
deflation13310653de_flation
deflection16147733defle_ction
defloration1547263defloration
dejection19178663deje_ction
delations102616593del__ations
delectations1547453delectations
delegacies1444033delegacies
delegate10410463delegat__e
delegated1238373delegat_ed
delegatee1148803delegat_ee
delegatees1244273delegatees
delegates1139843delegat_es
delegators1245633delegators
deletions102610933dele__tions
deliberation1546363deliberation
delineation1247763delineation
denervation1567943denervation
denigration1348463denigration
denotation11311083denotation
dentation10315243de_ntation
denudation1247303denudation
depilation13312033depilation
depletion1256663deple__tion
deprecation1648963deprecation
depredation1546923depredation
deputation1339393deputation
deregulation1446083deregulation
derivation14712783derivation
derogations1349393derogations
desecration14410073desecration
desertion10410203dese_rtion
designation1347483designation
desolation11311403desolation
desperation14510113desperation
detection121310413dete_ction
detention10169543dete_ntion
detestation1248363detestation
detonation11310943detonation
deuteration1249103deuteration
deviation13312393de_viation
dilatation1147393dilatation
dilation92215463dil__ation
divagation15104373divagation
elation73620453_el__ation
election102015353_ele_ction
elevations1338633_elevations
elongation1145353_elongation
federation1449573federation
fellation1238843fel_lation
gelation93014433gel__ation
generation11312423generation
hebetation1557093hebetation
legations102711923__legations
levigation1447023levigation
ligation92313093__ligation
negation92913023__negation
obligation1346783obligation
peltation11312963pel_tation
relation82619773rel__ation
relaxation1746453relaxation
relegating1239483relegating
relocation12312113relocation
revelation13410923revelation
segregation1346383segregation
selection11311273sele_ction
toleration1048963toleration
vegetation1448213vegetation
veneration13412343veneration

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 Filter1786911406030.1531167915.0
2DLD Change Limit1406031026.91020347.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.10925135.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.