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

183 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
deferred1310636(None) 
deferrer12135591deferrer
deterred10137801deterred
referred1297831referred
debarred12165632debarred
decerned1237262decerned
defeated132812162defeated
defected15289972defected
defenced1537202defenced
defended1437222defended
defensed1336222defensed
deferral1244352deferral
deferrers13115152deferrers
deforced15247372deforced
deformed15248262deformed
degermed1335452degermed
demerged13157602demerged
demurred1234932demurred
depermed1436452depermed
deserted101012202deserted
deserved13108132deserved
deterged11127922deterged
deterrer9137012deterrer
inferred12248352inferred
preferred1555002preferred
refereed12149692refereed
referrer11136052referrer
afeared1176833_afeared
averred11237593_averred
conferred1537753conferred
deaerated11311113deaerated
deafened1335853deafe_ned
deaired9411533de_aired
debarked16175823debarked
debeaked1634613debeaked
debeard1137353debear_d
debearded1443373debearded
deceased1247713deceased
deceived1535893deceived
decentred13236233decentred
declared1248743declared
decreed112710253de_creed
decried112612853de_cried
decurved1534843decurved
deeded94615543de_e_ded
deemed104713063de_e_med
deerweed1344183de_erweed
defaced142910973def_aced
defamed14309833def_amed
defanged1435433defanged
defatted1335673defatted
defeater122611663defeater
defecated1637493defecated
defence1339893defence_
defences1439633defences
defend113910493defe__nd
defender1337293defender
defense1137503defense_
defenses1237913defenses
defer94619753defe_r__
deferent122712873deferent
deferment151210303deferment
deferrals1343683deferrals
deferring1436143deferring
defers105116943defe_r_s
defied115016383def__ied
defiled124013103def_iled
defined123813823def_ined
deflated133412303deflated
defleaed1344943defleaed
deflected1635983deflected
deflexed2043873deflexed
defoamed15356243defoamed
defogged1533783defogged
deforce13267243deforce_
deforcer14246903deforcer
deforces14248403deforces
deformer14247943deformer
defraud1243913def_raud
defrayed1635403defrayed
defueled1374513defueled
defuelled1443123defuelled
defunded1435163defunded
defused125211093def_used
defuzed21447043def_uzed
degreed10258883de_greed
dehorned1345683dehorned
dehorted1357303dehorted
dejected19307593dejected
deleaded1148333deleaded
deleaved1346573deleaved
deleted93314903dele_ted
demarked16187223demarked
demeaned1237283demeaned
demented12311273demented
demerge11168023demerge_
demerger12127373demerger
demergered1543173demergered
demerges12129503demerges
demerited1339073demerited
demurrer1144043demurrer
departed1238823departed
depended1337983depended
deplored1237223deplored
deported1249703deported
descried1248073descried
deserter91211603deserter
deserve11108703deserve_
deserver12118383deserver
deserves12109893deserves
desexed1636173dese_xed
desired9311983de_sired
desorbed1236443desorbed
detected12289733detected
deterge9118463deterge_
deterger10147593deterger
deterges101510093deterges
deterrent10128943deterrent
deterrers10116593deterrers
detested10279623detested
detoured1036513detoured
deveined1336673deveined
develed123611933deve_led
devested13239133devested
devoured1335723devoured
dewormed15236223dewormed
differed1635523differed
diverged14256883diverged
diverted13199583diverted
dogeared1145793dogeared
dowered122811553dowe_red
emerged11158213_emerged
emersed10138513_emersed
erred65915673___erred
everted112711853_everted
exerted152210053_exerted
feared106320433__feared
ferrel92810203__ferrel
ferret93021173__ferret
ferried113411523__ferried
fevered14339723feve_red
furred104514433__furred
inferrer11217443inferrer
interred92615263interred
jeered143912793je_e_red
leered73816223le_e_red
levered114212303leve_red
metered103514013mete_red
offered1436143offe_red
peered93819483pe_e_red
petered103314963pete_red
preferrer1443893preferrer
recurred1137093recurred
refected142311663refected
refeed104717623refe__ed
refelled122810163refelled
refenced1438993refenced
referee101615753refe_ree
referees111310413referees
referral1144403referral
referrers12125373referrers
refired115116993ref_ired
reforged13268703reforged
reformed14249603reformed
refried113513873ref_ried
regeared1039433regeared
remerged12149173remerged
reperked15177793reperked
reserved121010583reserved
reverbed14269223reverbed
revered112819333reve_red
reversed122711613reversed
reverted122714713reverted
rezeroed1835993rezeroed
secerned1136103secerned
severed113513863seve_red
sewered112911243sewe_red
telfered1234883telfe_red
undeterred1263833undeterred
unfeared121511013unfeared
veered103612743ve_e_red
veneered1235983veneered
wafered14288433wafe_red

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621836.25023385.9
3Display Results1831830.0632904.8
 (SQL Overall)1786911836.46927622.7
 
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.