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

91 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
preferred155500(None) 
preferrer1443891preferrer
referred1297831_referred
deferred13106362_deferred
preaverred1642762preaverred
preferrers1542982preferrers
prefired144310752pref_ired
preformed17176202preformed
preserved15107562preserved
refereed12149692_refereed
referrer11136052_referrer
conferred1537753conferred
deferrer12135593_deferrer
deterred10137803_deterred
inferred12248353_inferred
misreferred1752193misreferred
peered93819493p_e_e_red
perfected1736643perfected
perfervid1842353perfervid
performed17155303performed
perverted1546103perverted
petered103314973p_ete_red
pilfered1435853pilfe_red
prearmed1397993pre_armed
preceded1438293prece_ded
precented14310693precented
precessed1437523precessed
precleared1544123precleared
precured1339993pre_cured
predried12309573pre_dried
preened103214993pre_e_ned
prefabbed1942323prefabbed
prefaced1638423pref_aced
prefaded1537823pref_aded
prefer113813203prefe_r__
preferment1746323preferment
preferring1645623preferring
prefers123713333prefe_r_s
prefigured1743313prefigured
prefiled143310573pref_iled
prefilled1535513prefilled
prefire124012813pref_ire_
prefires134313283pref_ires
prefixed21357703pref_ixed
prefunded1644693prefunded
preheated1539813preheated
prelected1439133prelected
premerger1444903premerger
premiered14237093premiered
prepared132210873pre_pared
prescored14409403prescored
presented12311633presented
preserve13108803preserve_
preserver14127013preserver
preserves14109073preserves
presorted1239453presorted
pressured1237333pressured
prestored125111673prestored
pretended1337193pretended
pretested12149113pretested
pretexted19135693pretexted
prevented1539003prevented
prewarmed17104563prewarmed
prewarned1594773prewarned
prewired14358473pre_wired
preworked1954653preworked
professed1545243professed
proffered1843433proffered
proverbed1743813proverbed
recurred1137093_recurred
refected142311663_refected
refeed104717623_refe__ed
refelled122810173_refelled
refenced1439003_refenced
referee101615753_refe_ree
referees111310413_referees
referral1144413_referral
referrers12125373_referrers
refired115116993_ref_ired
reforged13268703_reforged
reformed14249603_reformed
refried113513883_ref_ried
regeared1039433_regeared
remerged12149173_remerged
reperked15177793_reperked
reserved121010583_reserved
reverbed14269223_reverbed
revered112819333_reve_red
reversed122711613_reversed
reverted122714713_reverted
rezeroed1835993_rezeroed

Search took 9 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.453394461.4
2DLD Change Limit148641918.23618047.7
3Display Results91910.0461978.3
 (SQL Overall)178691918.73520456.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.