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

61 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
designated134593(None) 
designate1147111designate_
designates1246361designates
denigrated1366972denigrated
desiccated1644992desiccated
designator1244712designator
designed1136942design__ed
resinated10413282resi_nated
undesignated1552832undesignated
deaminated1448013deaminated
decimated1548953deci_mated
dedicated14310253dedi_cated
deigned1037503de_ign__ed
delegated1238373deleg_ated
delighted1546203delig_hted
delineated1246243delineated
denigrate1168693denigrate_
denigrates1298113denigrates
denitrated1298033denitrated
depilated1339653depi_lated
derogated1238673derog_ated
desalinated1345773desalinated
descanted1336673descan_ted
desecrated1447953desecrated
desiccate1445923desiccate_
desiccates1545383desiccates
desiderated1444943desiderated
designating1446073designating
designation1347483designation
designative1654333designative
designators1344303designators
designatory1653383designatory
designee1087753design__ee
designees1145003design_ees
designer1036543design__er
desisted1039783desi__sted
desolated1139653des_olated
despumated1643193despumated
desugared1242663desug_ared
detonated1138213de_tonated
deviated13311043devi__ated
dominated1339883domi_nated
emigrated1347073_emigrated
festinated1447533festinated
geminated1338553gemi_nated
hesitated1377783hesi_tated
levigated1445643levig_ated
pepsinated1545233pepsi_nated
predesignated1852313predesignated
presignaled1552383presignaled
reignited1145683re_ignited
remigrated1447493remigrated
resighted1436523resig_hted
resigned1038863resign__ed
resinate8316773resi_nate_
resinates9314763resi_nates
resituated1147323resituated
resonated10510613res_onated
signaled1035393__signaled
signeted1035973__signeted
vesicated15117653vesi_cated

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 Filter1786911406030.423422437.4
2DLD Change Limit140603616.17322777.1
3Display Results61610.0302033.3
 (SQL Overall)178691616.62626968.2
 
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.