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

86 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
delegable1313664(None) 
deletable12149501deletable
relegable1258101relegable
delayable1546062delayable
delectable15247382delectable
delegate10410462delega_te
delegatee1148802delegatee
depletable1544972depletable
believable1742723believable
dateable1149443date_able
debatable1446313debatable
decayable1745623decayable
deceivable1845023deceivable
decidable1547223decidable
declarable1544973declarable
declinable1545863declinable
defendable1754983defendable
deferrable1644853deferrable
definable1547773definable
deflectable1943803deflectable
deleave1147723dele_a_ve
delectables16144333delectables
delectably18125683delectably
delegacies1444033delegacies
delegacy1543533delega_cy
delegated1238373delegated
delegatees1244273delegatees
delegates1139843delegates
delegator1146243delegator
deliverable1753113deliverable
demisable1448533demisable
deniable11312083de_niable
denotable1238373denotable
dependable1645793dependable
deplorable1545073deplorable
deployable1843863deployable
deposable1446833deposable
deputable1487043deputable
derivable1548063derivable
desirable1249393desirable
detectable15136603detectable
deterrable1345723deterrable
detestable13136503detestable
detonable1247623detonable
devisable1546853devisable
dilatable1246853dilatable
disenable1249673disenable
dyeable1337303d_ye_able
electable13149623_electable
elegance1146373_elegance
eligible11114693_eligible
eyeable1239063_eye_able
feedable1437673fe_edable
fellable13179133fel_lable
fileable13179223file_able
gelable101710733gel__able
generable1238663generable
helpable1536603hel_pable
illegible1243783illegible
keepable1635323ke_epable
legible1035833__legible
meltable12310473mel_table
obligable1444383obligable
peelable1238553pe_elable
reefable1339533re_efable
reelable10311593re_elable
referable1439623referable
relatable11310053relatable
relaxable1836363relaxable
releasable1245483releasable
relegate9311243relega_te
reliable10313073rel_iable
relievable1544663relievable
relivable1438513relivable
renewable1447433renewable
reverable14310363reverable
saleable10312023sale_able
seeable91113943se_e_able
selectable14136443selectable
sellable101711823sel_lable
severable1438543severable
tellable10169773tel_lable
tolerable1147393tolerable
vegetable1545683vegetable
venerable1438483venerable
weldable1436863wel_dable

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.423422437.4
2DLD Change Limit148641866.40623203.4
3Display Results86860.0302866.7
 (SQL Overall)178691866.85926052.0
 
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.